Thread: min query
View Single Post
  #1  
Old May 27th, 2010, 10:07 PM posted to microsoft.public.access.queries
Siew-Ming
external usenet poster
 
Posts: 5
Default min query

Hi,

How do I get the 2nd minimum value and the 3rd minimum from a table after I
have done MIN query for the 1st minimum value?

SELECT dbo_CON.SC, dbo_CON.SN, Min(dbo_CON.SQ) AS MinOfSQ
FROM dbo_CON
GROUP BY dbo_CON.SC, dbo_CON.SN
HAVING (((dbo_CON.SC)49));

Thanks,