Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by lgf
-
How to pick up rows and put them like columns...
I, I want to handle this select statement as follow: select col1, col2 from table This select statement return 2 lines: col1 col2 ---- ---- BasketBall 2 points BasketBall 3 points Now, i want to use a simple select statement to give me one single row, like this: col1...- lgf
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
How can i reuse an alias column, in a same select statement?
I wish to execute the following SQL statement: select round(col1 * 2) result_col1, (result_col1 - 2) col2 from table_test The result is: >Invalid column name I don't want to use an another view or any object else... I just want to reuse a column alias... Thanks a lot for your help.... It's...- lgf
- Thread
- Replies: 2
- Forum: Oracle: All versions
