Answer / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Answer / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

Answer / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

Answer / ajay kumar

SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N

Answer / sachin saini

select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )

Answer / abhijt shinde

select MIN(salary) from Employees
where salary IN
(Select Top 3 salary from Employees order by salary desc)

Select Top 1 salary from Employees where salary
Not IN(select Top 1 salary from Employees order by salary Desc)
order by salary Desc

Answer / arindam

select min(sal) from
(
select sal from
(
select distinct sal from emp order by sal desc
)
where rownum<=3
)
where rownum <4

Answer / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

Answer / vishal beri

Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)

Answer / suneel

select level,max(sal)from af where level=3 connect by prior
sal>sal group by level;

Why do we use cursors?

0 Answers  

What company owns postgresql?

0 Answers  

Who developed sql?

0 Answers  

Explain what is an index?

0 Answers  

What is sql*loader and what is it used for? : aql loader

0 Answers  

What is the purpose of my sql?

0 Answers  

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

Does truncate remove indexes?

0 Answers  

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

What is the difference between truncate and drop statements?

0 Answers  

What are the two types of periodical indexes?

0 Answers  

How do you break a loop in pl sql?

0 Answers