Answer / akula

select min(sal) from(select distinct(sal) from emp order by sal desc) where rownum<=3;

Answer / dulal

Without Using MAX or MIN keyword


select TOP 1 EmpName, RevisedMinutes
from tblEncounter
where RevisedMinutes IN(select distinct Top 3
RevisedMinutes from tblEncounter order by RevisedMinutes
desc)
order by RevisedMinutes asc

Answer / srinivas

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

Answer / kotesh

select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;

Answer / pavan ranga

select top 1 (salary),Name from customers
where salary not in (Select top 2 (Salary) from customers)

Answer / a.brahmam

select * from(select rownum r,sal from(select * from table name order by sal desc))
where r=3;
(or)
select * from(select rownum,sal from table name order by sal desc)
where rownum<=3
minus
select * from(select rownum,sal from table name order by sal desc)
where rownum<=2
(or)
select * from(select sal,dense_rank()over(order by sal desc)r from table name)
where r=3

Answer / rutujagabhane

SELECT *
FROM(
SELECT SALARY, DEPARTMENT_ID,EMPLOYEE_ID, DENSE_RANK() OVER (PARTITION BY DEPARTMENT_ID ORDER BY SALARY DESC) AS RN
FROM EMPLOYEES
)
WHERE RN = 2
;

Answer / neeraj

SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary
ORDER BY Salary DESC;]
ORDER BY Salary;

Answer / akilis.org@hotmail.com

Let us Assume
Table Name=salary
Column Name=maxsal

select * from salary order by maxsal desc limit 2,1;

Enjoy the simple code :)

Answer / kumar sumit

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

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

Can we enter data in a table in design view?

0 Answers  

What is foreign key and example?

0 Answers  

What program will open a mdb file?

0 Answers  

What is pragma in sql?

0 Answers  

Why truncate is faster than delete?

0 Answers  

What does count (*) mean in sql?

0 Answers  

Explain commit, rollback and savepoint.

0 Answers  

Can we create index on primary key?

0 Answers  

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

How many tables can a sql database have?

0 Answers  

What are the different schemas objects that can be created using pl/sql?

0 Answers