St3veMax | SQLServerCentral

St3veMax

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

RE: Does ORDER BY clause matters if we have also used a TOP clause in query?

Apologies; The above posters are correct - I mis-read your comment...

September 6, 2011 at 2:33 am

#1377225
RE: Does ORDER BY clause matters if we have also used a TOP clause in query?

kirti.malukani (9/6/2011)
Yes, but I already have a clustered index on my salary column so do I need any external sorting as well?
No; The clustered index physically sorts the data in...

September 6, 2011 at 2:16 am

#1377215
RE: Does ORDER BY clause matters if we have also used a TOP clause in query?

Select TOP X just limits the result set to the top X records; so if you sort by salary desc; then selecting the top 5 would give you your desired...

September 6, 2011 at 2:11 am

#1377213

Viewing 3 posts - 1 through 3 (of 3 total)