min query

  • Thread starter Thread starter Siew-Ming
  • Start date Start date
S

Siew-Ming

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,
 
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
 
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.SC<>49
ORDER BY Min(dbo_CON.SQ) ;
 
Back
Top