Home » SQL & PL/SQL » SQL & PL/SQL » Can I assign an alias for a group of columns?
Can I assign an alias for a group of columns? [message #18665] Sun, 10 February 2002 06:26 Go to next message
seewhy
Messages: 1
Registered: February 2002
Junior Member
Hi!
I am just wondering whether it is possible if assign an alias for multiple columns. For example, can I say:
Select (column1, column2) as alias from table 1.
then use the alias to link other tables?
Thank you very much!

Sincerely,
seewhy
Re: Can I assign an alias for a group of columns? [message #18683 is a reply to message #18665] Mon, 11 February 2002 02:06 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

it is not possible.you can do like this

Select column1 alas1, column2 alias2 from table 1.

cheers
pratap
Previous Topic: select statement
Next Topic: How to select "last but one row" from a table?????
Goto Forum:
  


Current Time: Thu Mar 28 04:09:01 CDT 2024