Answer / ajit nayak

select *from emp
minus
select *
from emp
where rownum <= (select count(*)-3 from
emp);

Answer / swastik

SELECT * FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)
WHERE ROWNUM <= 3;

Answer / ashwin

if emp table is having 10 records then
1)for first 6 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum <7;

2)for last 3 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum >7;

Answer / sanjay

SELECT ROWNUM AS rank, employee_id
FROM (SELECT employee_id
FROM employees
ORDER BY employee_id DESC)
WHERE ROWNUM<=3

Answer / shekaran04

Hi,
First thing you cannot use " ROWNUM > (somthing) "
And to get last three records...

Select *from emp
minus
Select *from emp where rownum <(select Count(*) from emp)-
3;

Good Luck...

Answer / mohammed shahid

select distinct TOP3 from emp order by rownum desc;

How many databases can sql express handle?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

what is bulk bind

4 Answers   TCS,

How delete all data from table in sql?

0 Answers  

How many types of normalization are there?

0 Answers  

What is a common use of group by in sql?

0 Answers  

What is difference between pl and sql?

0 Answers  

what are aggregate and scalar functions? : Sql dba

0 Answers  

What is user defined functions?

0 Answers  

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

What is the main difference between sql and pl/sql?

0 Answers  

What are the pre requisites?

1 Answers