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;

Store procedure will return a value?

4 Answers   eMids,

How do I delete a trigger?

0 Answers  

Is primary key an index?

0 Answers  

Can u create a primary key with out unique index.

8 Answers  

What is the process of debugging?

0 Answers  

What is left join in sql?

0 Answers  

What is memory optimized?

0 Answers  

What is the example of procedure?

0 Answers  

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

what is oracle database ? : Sql dba

0 Answers  

What is sql resultset?

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers