MySQL Forums
Forum List  »  PostgreSQL

rearrange columns
Posted by: amit hasija
Date: August 14, 2008 04:25AM

i have four records with 4 columns each,

i want to fetch 2 column as first in dataset wat can i do.

col1 col2 col3 col4
1 2 3 4
1 2 3 4

i want a query to fetch recordset like

col2 col1 col3 col4
2 1 3 4
2 1 3 4

but the select query must be written in sequence select col1,col2,col3,col4 .....

Options: ReplyQuote

Written By
rearrange columns
August 14, 2008 04:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.