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 is PL/SQL Records?

0 Answers  

What is a sql driver?

0 Answers  

What is an ndf file?

0 Answers  

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

Is subquery faster than join?

0 Answers  

How do you update a sql procedure?

0 Answers  

Explian rowid, rownum?

0 Answers  

What are pl sql data types?

0 Answers  

What is the current version of postgresql?

0 Answers  

Can procedure in a package be overloaded?

1 Answers   HCL,

what is an extent ? : Sql dba

0 Answers