| Author: Sumi Esakkiappan 26 Mar 2007 | Member Level: Silver | Rating:  Points: 2 |
Select * from Employee where salary = (Select max(Salary) from Employee)
|
| Author: RamarajSundaram 26 Mar 2007 | Member Level: Diamond | Rating: Points: 2 |
select e.sal from emp e where 4=(select count(*) from emp where sal<=e.sal)
|