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

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

Question Posted / l meher

Answer Posted / l meher

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

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how do you know if your mysql server is alive? : Sql dba

781

Can we use joins in subquery?

796

What are its different types of dbms?

715

explain the options of myisamchk to improve the performance of a table. : Sql dba

723

What is ttitle and btitle?

768

What is the benefit of foreign key?

716

What is raid? How does it help storage of databases?

802

Is sql low level language?

757

How does a covering index work?

694

What is difference between table and view?

708

Define union, minus, union all, intersect ?

740

how to dump a table to a file with 'mysqldump'? : Sql dba

741

Can we create foreign key without primary key?

705

Does sql use python?

758

Does access use sql?

750