Answer / yadunandan

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

Answer / anilchandu

Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)


where x,y are alias names.

If you want 3rd heighest salary then just replace 2 by 3

Answer / manjeet

select max(sal) from emp where sal not in (select max(sal)
from emp)

Answer / prabhudatta barick

--IN ORDER TO FIND THE NTH HIGHEST SALARY,
--WE JUST FIND THE SALARY THAT HAS EXACTLY N-1 SALARIES
GREATER THAN ITSELF---

--This is correlated subquery--
select empno,
ename,
sal
from scott.emp e
where &n-1=(select count(distinct b.sal) from scott.emp b
where b.sal>e.sal);

To get second highest salary put n value 2.

Answer / rakhi

SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;

Answer / amit bhagat

select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2

How do we know whether an index is created on a table ???

2 Answers   TCS,

What is Trigger in Oracle?

0 Answers   MCN Solutions,

what is the difference between table and veiw?

4 Answers   IBM,

What is Reduced List of Values?

0 Answers   iFlex,

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

Explain the use of full option in exp command.

0 Answers  

Explain oracle’s system global area (sga).

0 Answers  

Why cursor variables are easier to use than cursors?

0 Answers  

What are the various types of snapshots ?

0 Answers  

What is a directory object?

0 Answers