select * from emp where rownum>= (select count(*)-10 from emp);

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

Question Posted / chandrakishan

Answer Posted / chandrakishan

select * from emp where rownum>=
(select count(*)-10 from emp);

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is primary key is clustered index?

986

How to disable a trigger name update_salary?

1251

How can you fetch common records from two tables?

1046

What is view? Can we update view

1411

What is server name sql?

1122

What are sql functions? Describe the different types of sql functions?

1122

How do temporal tables work?

939

Does pl/sql support create command?

1086

What are the various levels of constraints?

1114

Why do we need cursor in pl sql?

1121

How does left join work in sql?

985

What is a schema? How is it useful in sql servers?

1096

What is foreign key and example?

917

How do I run a script in sql developer?

935

Explain the order of sql statement execution?

1028