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
26469 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

Is primary key clustered or nonclustered?

972

What is ttitle and btitle?

1030

What is a ddl command?

1031

Explain sql data types?

1053

What is the use of index in hive?

982

What is rownum and rowid?

1001

What are some emotional triggers?

946

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

986

What is the purpose of a secondary key?

923

Is sql a dbms?

951

What is pl sql block structure?

992

what is column? : Sql dba

979

What are inbuilt functions in sql?

1013

Is left join inner or outer by default?

990

Does sql support programming?

1027