this is a SQL query

SELECT DISTINCT salary FROM  employee WHERE(max(salary))

Hi,

  Select * from emp e where 2>=(select count(*) from emp e 
where sal>e.sal) order by  desc sal.

  Let me know if this query is wrong.

Hi,
This is suresh.
My answer for that query is

select top 2(salary)from emp order by salary desc

SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2 
SALARY FROM EMP ORDER BY SALARY DESC.

    OR 
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.

hi this is charan,
        select e1 *from employees e1
         where 2>
         ( select column(distincte2.sal)           
            where e2.sal>e1.sal   )

select salary from (select salary from emp order by salary 
desc)
where rownum < 3;

SELECT MIN (SALARY) FROM EMP WHERE 

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY 
SALARY DESC)

select top 2 salary from employee order by desc

select salary
from emp
where rownum <= 2
order by salary.

this query will list top 2 salaries

select max(sal)
from emp
where sal < (select max(sal) from emp);

with this query u ll get second largest sal of that table
 if u want to know max (sal) then it ll be...
select Max(sal)
from emp;