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

Why is pl sql used?

966

What are the usages of sql?

1047

Can you join a table to itself?

1108

what is a materialized view? : Sql dba

1048

How to run sql functions in pl/sql?

1041

What is a delimiter in sas?

1035

What is the need of merge statement?

1012

What is database sql?

1032

How to pronounce postgresql?

1033

Explain dml and ddl?

963

When sql appeared?

1071

What is dml and ddl?

934

What is difference between sql function and stored procedure?

990

How can the performance of a trigger be improved?

1022

What kind of join is join?

947