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 the difference between jpql and sql?

0 Answers  

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

What is difference between sql and excel?

0 Answers  

How to take user input in pl sql?

0 Answers  

Can we use join in subquery?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

can i call procedure in package

3 Answers   TCS,

What are expressions?

0 Answers  

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

Can procedure in package be overloaded?

0 Answers   EXL,