MIN Function

T

Tom

Instead of finding the "lowest" value of a records set (e.g. "5" out of a
record set "10, 5, 70, 25, 30, 100"), I'd like to find the "lowest three"
records.... "5, 10, 25".

Is that possible? Is yes, how would I go about it?

Thanks,
Tom
 
D

Douglas J. Steele

See whether you can use the TOP predicate.

Something like:

SELECT TOP 3 Field1, Field2, Field3
FROM MyTable
ORDER BY Field1 ASC

will give you the 3 rows associated with the lowest 3 values of Field1
 
Top