March 13, 2013 at 10:42 pm
Hello all!
How could I return the top ten highest values in a column? WOuld it be somewhere along the lines of Select Top(10) StudentScore from dbo.Employees?
The output would be along the lines of this:
100
99
66
54
33
etc...Does anyone know how? thanks
March 13, 2013 at 10:47 pm
what happened when you tried it?
looks like the only thing missing is the ORDER BY clause to force a sort in descending order (so you get the highest values)
March 13, 2013 at 10:53 pm
use select statement followed by order by columnname DESC
--Pra:-):-)--------------------------------------------------------------------------------
March 13, 2013 at 10:58 pm
Ok...that makes sense..I kept thinking I was doing something wrong. thanks guys.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy