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);

What are string functions in sql?

0 Answers  

How you improve the performance of sql*loader? : aql loader

0 Answers  

What are different types of refreshment techniques of materialised view

2 Answers  

Which command is used to delete a package?

0 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

What is the difference between anonymous block and named blocks?

3 Answers  

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

Which is better join or subquery?

0 Answers  

what is datawarehouse? : Sql dba

0 Answers  

What is the basic form of sql query?

0 Answers  

How to load data with sql*loader?

0 Answers  

Is progress software supports to ( pl/sql )?

0 Answers