i have one table.that contains one salary field.I want to find the third maximum row from that field.If anyone knows this please help me
thanks
rajesh79 0 Newbie Poster
Recommended Answers
Jump to Posthmmm,
SELECT MIN(column) FROM table WHERE ( SELECT TOP 3 (column) FROM table ORDER BY column desc )
Jump to PostRamyMahrous' solution doesn't work. Use this instead. select min(s.column) from (SELECT TOP 3 (column) FROM table ORDER BY column desc) s
All 8 Replies
ericstenson 5 Posting Whiz in Training Team Colleague
select top 3 COLUMNAME from TABLENAME order by COLUMNAME desc
The first row will be your third highest paid person.
Ramy Mahrous 401 Postaholic Featured Poster
hmmm,
SELECT MIN(column) FROM table WHERE ( SELECT TOP 3 (column) FROM table ORDER BY column desc )
ericstenson 5 Posting Whiz in Training Team Colleague
go with the whiz... :)
Ramy Mahrous 401 Postaholic Featured Poster
@erictenson:
sorry??
nav33n 472 Purple hazed! Team Colleague Featured Poster
@erictenson:
sorry??
:) RamyMahrous -> Posting Whiz! Thats what he meant, I guess.
pclfw 23 Junior Poster
RamyMahrous' solution doesn't work. Use this instead. select min(s.column) from (SELECT TOP 3 (column) FROM table ORDER BY column desc) s
Ramy Mahrous 401 Postaholic Featured Poster
Yes, yes I am sorry I was wrong thanks, pclfw :)
manips 0 Newbie Poster
yours soln is very useful for my solution.I join dis community bcz of ur answer
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.