Member Avatar for rajesh79

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

  • 6 Contributors
  • 8 Replies
  • 78 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by manips
Member Avatar for ericstenson

select top 3 COLUMNAME from TABLENAME order by COLUMNAME desc

The first row will be your third highest paid person.

Member Avatar for Ramy Mahrous

hmmm,
SELECT MIN(column) FROM table WHERE ( SELECT TOP 3 (column) FROM table ORDER BY column desc )

Member Avatar for ericstenson

go with the whiz... :)

Member Avatar for Ramy Mahrous

@erictenson:
sorry??

Member Avatar for nav33n

@erictenson:
sorry??

:) RamyMahrous -> Posting Whiz! Thats what he meant, I guess.

Member Avatar for pclfw

RamyMahrous' solution doesn't work. Use this instead. select min(s.column) from (SELECT TOP 3 (column) FROM table ORDER BY column desc) s

Member Avatar for Ramy Mahrous

Yes, yes I am sorry I was wrong thanks, pclfw :)

Member Avatar for manips

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.