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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lgf
  • Order by date
  1. 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...
  2. lgf

    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...

Part and Inventory Search

Back
Top