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

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

Question Posted / hussain

Answer Posted / hussain

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I save a sql query?

1021

What are the constraints available in sql?

1051

What are the query optimization techniques?

941

Can we use two order by clause in query?

969

what is user defined functions? : Sql dba

1037

what is the difference between join and union? : Sql dba

1122

What is natural join in sql?

997

How many sql are there?

1005

What is dense_rank?

937

What is the difference between in and between in sql?

1068

When you have to use a default "rollback to" savepoint of plvlog?

1204

What is an index in sql with example?

979

Why is theta join required?

1149

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1098

What does plv msg allows you to do?

1147