Answer / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

Answer / ajeshanath

select max(salary) from emp where salary not in
(select max(salary) from emp)

Answer / amy

select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc

Answer / praveen kumar.dandu

select a.sal,rank from(select sal,rank() over (order by sal
desc))a where rank=&n




<Here after printing the ranks we can retrieve we can
retreive what ever the rank we want>

Answer / sunil

select top 1 * from emp where sal not in (select max(sal)
from emp) order by sal desc

Answer / gokul

In MySQL, this query will be easier to find 2nd highest
salary and to fetch all the fields from a table.

select * from emp where sal not in (select max(sal)
from emp) order by sal desc limit 1

Answer / lakshmi

select * from (select *,rowcount()over (orderby emp desc)as
rank from emp)b where rank=2

Answer / abhijit banik

To get the n-th highest salary from employee table in oracle-10g
--------------------------------------------------------------
select min(salary)
from
(
select rownum rn, salary
from
( select distinct(salary) from employee order by salary desc )
)
where rn<=&n+1

Answer / arvind

rameshwari r u idiot dont u know the ans for this simple
que... worst fellow

Answer / sreekanth

SELECT MIN(SAL)
FROM(SELECT distinct SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where N is the Nth highest salary u want

What is indexing oracle sql?

0 Answers  

What is sap sql anywhere?

0 Answers  

write a query to delete similar records in different tables with same structure

4 Answers  

Is sql procedural language?

0 Answers  

What is sql table?

0 Answers  

What is the difference between an inner and outer join?

0 Answers  

What is query syntax?

0 Answers  

How do you explain an index?

0 Answers  

how to shutdown mysql server? : Sql dba

0 Answers  

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

describe transaction-safe table types in mysql : sql dba

0 Answers