Friday, June 27, 2008

Query for Display second max salary of Employee

select * from newemployee em where
2=(select count(distinct sal) from newemployee e where e.sal<=em.sal).

No comments: