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 are the advantages of pl sql over sql?

0 Answers  

Define a temp table?

0 Answers  

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

Can dml statements be used in pl/sql?

0 Answers  

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

Is coalesce faster than isnull?

0 Answers  

What is difference between table and view?

0 Answers  

What is the maximum number of columns in sql table?

0 Answers  

What is union and union all keyword in sql and what are their differences?

0 Answers  

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

How to get unique records from a table?

0 Answers