Thursday, March 4, 2010

What is the Querry for retrieving the 2nd highest

select max(salary) from where salary! (select max(salary) from )
Posted by at
Labels: ,

1 comment:

  1. AnonymousJune 11, 2010 at 11:23 PM

    Informix: select max(salary) from Table a where a.salary < (select max(salary) from Table)

    ReplyDelete

Subscribe to: Post Comments (Atom)