Answer / jprakash025

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

or



SQL> select * from
2 (select rownum a, emp.* from emp)
3 where
4 a>(select max(rownum)-10 from emp);

Answer / l meher

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

Answer / praveen biradar

select empno from (select empno from emp order by empno
desc) where rownum<=10 order by empno

Answer / pallavi v

with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10

Answer / siddharthapenchala

select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)

Answer / nzabin

select PO_header_id from (select PO_header_id from PO_HEADERS_ALL order by PO_header_id
desc) where rownum <=10 order by PO_header_id;

Answer / sudhir

select rownum, p.*
from (select * from <table name> order by param_cd desc) p
where rownum <= 10 ;

Answer / akshaya

select * from last10
minus
select * from last10
where row >= (select COUNT(*)-10 from last10)


condition should be >= not <=
for all the above queries

Answer / swastik

SELECT ROWNUM, E1.*
FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)E1
WHERE ROWNUM <= 10

Answer / chandrakishan

select * from emp where rownum>=
(select count(*)-10 from emp);

Explain constraints in sql?

0 Answers  

what is sql optimization

1 Answers   Fidelity,

How you will create Toad Function?

1 Answers  

How to fetch common records from two tables?

1 Answers  

Is left join inner or outer by default?

0 Answers  

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

What is the difference between clustered and non-clustered index in sql?

0 Answers  

What are triggers in sql?

0 Answers  

What is sql scripting?

0 Answers  

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

Are views faster than queries?

0 Answers  

what is explain plan?, given an example...

3 Answers   Polaris,