Answer / ritesh sabanis

select max(sal) from employeedata where sal <
(select max(sal) from employeedata where sal not in(select
max(sal)from employeedata)) ;

Answer / divya c

Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));

Answer / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

Answer / dharmendra yadav

select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;

Answer / jeevitha

select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n

Answer / suba

(Instead of 3 we can find N highest value)

select min(sal) from emp e where 3>(select count(sal) from
emp where sal>e.sal);

Answer / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Answer / aarti verma

get the 3rd highest salary:

SELECT DISTINCT salary from employee e ORDER BY salary DESC
LIMIT 2,1;

get the records of employees having 3rd highest salary:

SELECT * FROM employees WHERE salary = (SELECT DISTINCT
salary from employee e ORDER BY salary DESC LIMIT 2,1);

Answer / himanshu

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / vikram kumar

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

What is a null value?

0 Answers  

Explain how to use transactions efficiently : transact sql

0 Answers  

Explain the select statement in sql?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

What is difference between cursor and trigger?

0 Answers  

how to create object in plsql

3 Answers   Microsoft,

Which one is faster ienumerable or iqueryable?

0 Answers  

What is gpt format?

0 Answers  

what is the purpose of update command in oracle?

7 Answers   MBT,

What is the maximum size of sqlite database?

0 Answers  

How to use boolean type in select statement?

0 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,