3 highest values in query

A

AK

Hello,
How to display 3 highest (smallest) values in sql query (without Max. values
field) .

Andrzej
 
M

Michel Walsh

Hi,


SELECT TOP 3 list_of_fields
FROM somewhere
ORDER BY FieldHoldingTheHighestWhat [ ASC | DESC ]


The order by can be a list of fields, or expressions.


Hoping it may help,
Vanderghast, Access MVP
 

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

Query Question 2
Value over ride in Query, Choose the highest value in Query, need 2
return 3 highest values 1
Choose the highest and second highest from three field 7
Query to select the highest 3 numbers 2
Queiry to return highest value or number in a field 6
Subquery Help? 3
Comparing weeks with highest and lowest sales Query--HELP 6

Top