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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculate a row number column in the results of a Select statement ?
I don't believe I will be able to achieve it through distinct or count(*) so I may have explained it ambigously... I want the results from select 1... somecol ------- 'Apples' 'Pears' 'Bannas' Merged with the results from select 2... somecol ------- 'grapes' 'lemons' 'kimi fruits' but the...- sb001
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Calculate a row number column in the results of a Select statement ?
I want to union several select statements together to form a single result set that them ordered with an even distribution of the rows from each of the individual selects. i.e If first SELECT returns... COL1 ROWNUM ---- ------ 'ABC' 1 'DEF' 2 'GHI' 3 and a...- sb001
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
