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


Subject
Views
Written By
Posted
rearrange columns
9734
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.