select * from emp minus select * from emp where rownum<=(se

Write a query to get last 10 records from the table.

Question Posted / jprakash025

12 Answers
26498 Views
iNautix, I also Faced
E-Mail Answers

Answer Posted / 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);

Is This Answer Correct ?

24 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the qualities of 2nf?

996

Is not equal in sql?

978

What is a full join?

936

What is sap sql?

947

What is the use of prepared statement?

974

What does where 1 1 mean in sql?

998

Are views faster than queries?

947

What is consistency?

1085

How much does sql cost?

959

What are the parameter modes supported by pl/sql?

1043

What is scope of pl sql developer in future?

980

What is clustered index sql?

963

How to run sql statements through the web interface?

1010

What is sql entity?

1057

What is a function in oracle pl sql?

1005