how to get ten lower values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hii i have a question in my mind that i want someone to solve that i tried
alot and thought of it alot . the question is that how to get the ten or less
or more lower values in the querry as we get top values in querry. thanks in
advance.
 
Same way you the the top "large" values, except use an ORDER BY clause that
is DESC for the field in question.
 
hii i have a question in my mind that i want someone to solve that i tried
alot and thought of it alot . the question is that how to get the ten or less
or more lower values in the querry as we get top values in querry. thanks in
advance.
Click to expand...

Have you tried

SELECT Top 10 vValues from tblTable order by vValues desc

I admit that I performed the test in SQL2000 Desktop Edition.
 
Back
Top