Answer / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

Answer / ajeshanath

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

Answer / amy

select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc

Answer / praveen kumar.dandu

select a.sal,rank from(select sal,rank() over (order by sal
desc))a where rank=&n




<Here after printing the ranks we can retrieve we can
retreive what ever the rank we want>

Answer / sunil

select top 1 * from emp where sal not in (select max(sal)
from emp) order by sal desc

Answer / gokul

In MySQL, this query will be easier to find 2nd highest
salary and to fetch all the fields from a table.

select * from emp where sal not in (select max(sal)
from emp) order by sal desc limit 1

Answer / lakshmi

select * from (select *,rowcount()over (orderby emp desc)as
rank from emp)b where rank=2

Answer / abhijit banik

To get the n-th highest salary from employee table in oracle-10g
--------------------------------------------------------------
select min(salary)
from
(
select rownum rn, salary
from
( select distinct(salary) from employee order by salary desc )
)
where rn<=&n+1

Answer / arvind

rameshwari r u idiot dont u know the ans for this simple
que... worst fellow

Answer / sreekanth

SELECT MIN(SAL)
FROM(SELECT distinct SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where N is the Nth highest salary u want

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

Explain architecture of sql server notification services?

0 Answers  

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

What is a rank in sql?

0 Answers  

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

What is the use of sqlerrd 3?

0 Answers  

How many types of triggers are there in pl sql?

0 Answers