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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to select any last record in the querry 5
Subject: Need help on Iff Statement 1
Group By Desing View 4
How to count consecutive records base on 2 groupings 0
Top Ten Albums 10
many querries into report 4
how secure any idea. 5
I need to find a querry to do this 8

Back
Top