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 type of join is sql join?

0 Answers  

Explain sql data types?

0 Answers  

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

What is exit statement?

0 Answers  

What is the size of partition table?

0 Answers  

What is the order of sql select?

0 Answers  

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

What are some predefined exceptions in pl/sql?

0 Answers  

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

what is the difference between binary_integer and pls_integer

2 Answers   TCS,