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

Can one improve the performance of sql*loader? : aql loader

585

Can we join two tables without common column?

512

What is minus?

541

In a distributed database system, can we execute two queries simultaneously?

567

what are null values? : Sql dba

541

Is it possible to read/write files to-and-from PL/SQL?

650

how to calculate expressions with sql statements? : Sql dba

524

What is trigger in sql?

576

What are local and global variables and their differences?

580

Name some usages of database trigger?

559

Does sql*plus have a pl/sql engine?

566

what are the limitations of identity column? : Transact sql

604

Explain the types of joins in sql?

571

What is db journal file?

516

What is a schema sql?

529