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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL subselect help needed...
I'm attempting to use the following query to return a sum of hours when a flag in the db is set to a certain code('P') or if its not set at all. The first subselect returns 3 records, the second only returns 1 record and the result is that all 3 records have the value from the second subselect...- rojo
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Selecting distinct rows
I'm trying to convert a DB2 query to use in SQL server, any help on the exact syntax would be appreciated, here's the DB2 query: select distinct column_x from table_y fetch first n rows only thanks...- rojo
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
