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;

What can sql server reporting services do?

0 Answers  

What is a file delimiter?

0 Answers  

With out using count() function. How to the find total number of rows in a table?

6 Answers  

What are the disadvantages of not performing database normalization?

0 Answers  

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

Why do we use set serveroutput on?

0 Answers  

Explain raise_application_error.

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

what is clause? : Sql dba

0 Answers  

What is the difference between a database and a relational database?

0 Answers  

How do I save a stored procedure?

0 Answers