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

What is the purpose of normalization?

997

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What is the difference between a primary key and a clustered index?

934

How is data stored in sql?

1005

Why schema is used in sql?

987

How do I clear the screen in sql plus?

984

explain advantages of myisam over innodb? : Sql dba

1017

What is the main difference between sql and pl/sql?

1028

Can you join views in sql?

897

what are set operators in sql? : Sql dba

985

What are the events on which a database trigger can be based?

1103

Can you inner join the same table?

938

what is the difference between $message and $$message? : Sql dba

946

Why functions are used in sql?

932

what is self join and what is the requirement of self join? : Sql dba

1078