Home » RDBMS Server » Server Administration » How can I find Nth minimum number
How can I find Nth minimum number [message #370749] Sat, 29 January 2000 14:25 Go to next message
Kamalesh Kumar
Messages: 1
Registered: January 2000
Junior Member
Hi All

Any one know Nth minimum number query (Just reverse of Nth Max Number ) then please let me know

I have urgent this one .

Thanks in advance .
Re: How can I find Nth minimum number [message #370750 is a reply to message #370749] Sun, 30 January 2000 07:25 Go to previous message
Paul
Messages: 164
Registered: April 1999
Senior Member
Kamalish,
If no duplicates possible:
SELECT empno
FROM emp a
WHERE 5 > ( SELECT COUNT(empno)
FROM emp b
WHERE b.empno ORDER BY empno;

If duplicates are possible:

SELECT DISTINCT(a.sal)
FROM emp a
WHERE 5 > ( SELECT COUNT(DISTINCT(b.sal))
FROM emp b
WHERE b.sal GROUP BY a.sal
ORDER BY a.sal;

Regards,
Paul
Previous Topic: Calling Stored Procedures from ASP page.
Next Topic: Using Decimal Point in substr parameters
Goto Forum:
  


Current Time: Thu Mar 28 18:09:41 CDT 2024