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 data manipulation language? : Sql dba

1022

How do I create a sql database?

1008

What are the types of index in sql?

1071

How do I partition a table in sql?

1138

What is difference between hql and sql?

1085

What are the two types of exceptions in pl/sql?

1053

How many sql core licenses do I need?

952

How do you remove duplicates without using distinct in sql?

984

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1018

What are sql ddl commands?

1099

What is scope of pl sql developer in future?

1027

What is attribute indicator in pl sql?

1017

What is your daily office routine?

2274

What is the use of triggers?

1039

Explain the advantages and disadvantages of stored procedure?

1153