Answer / radha sri seshu.kolla

select max(sal) from emp where level=2 connect by prior
sal>sal group by level;

Answer / shalina bajaj

select sal from emp a
where $number = (select count(distinct(sal))
from emp b
where a.sal <= b.sal);

Answer / prasanthi

select * from (select rownum r,a.* from (select distinct
sal from emp order by sal desc)a)where r=&i

sql>enter i value(enter manually) 2

Answer / prasanna

select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)

Answer / ved

select sal from emp
where limit,1
order by sal desc

Answer / raghavendraprasad

select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);

Answer / ramesh lavanuru

SELECT sal1 "salary"
FROM (SELECT ROWNUM rownum1 ,sal1
FROM (SELECT sal sal1
FROM emp
ORDER BY sal DESC
)
)
WHERE rownum1=:p_highest;

Note:- 'p_highest' here we can give the number as we want
to display the highest salary.

Answer / avinav

By using the rank function we can get the 2nd highest
salary from the emp table

Answer / pradeep

select sal from emp
where rownum=2
order by sal desc

Answer / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

What is nvarchar max in sql?

0 Answers  

What is the purpose of the primary key?

0 Answers  

What are the types of join and explain each?

0 Answers  

What is the cause of mutating table error and how can we solve it?

0 Answers  

What is difference between stored function and application function?

0 Answers  

What is synonyms?

0 Answers  

What are variables in pl sql?

0 Answers  

What do you understand by pl/sql packages?

0 Answers  

What is procedure explain with program?

0 Answers  

What is primary key and foreign key?

0 Answers  

What are the types of sql commands?

0 Answers