Hi Jerry,

This will give me three different SC SN records. I am looking for same SC
SN records that has next min SQ.

table
SC SN SQ
1 100 1
1 100 2
1 100 3
1 100 4
1 200 2
1 200 3
1 200 4
1 200 5
1 300 1
1 300 3
1 300 4
1 300 5

My expect result from the 1st min query

1 100 1
1 200 2
1 300 1

My expect result from the 2nd min query
1 100 2
1 200 3
1 300 2

My expect result from the 3rd min query
1 100 3
1 200 4
1 300 3


I also need to accomodate two SQ records per SC SN records. What to do no
third SQ rec?


Thanks,
SM

"Jerry Whittle" wrote:

SELECT TOP 3 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.SC49
ORDER BY Min(dbo_CON.SQ) ;
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Siew-Ming" wrote:

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,