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 .

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 01 11:32:11 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.