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

Which type of cursor is used to execute the dml statement?

996

What makes a good primary key?

1096

Explain correlated query work?

1110

What's the difference between a primary key and a clustered index?

1029

List and explain the different types of join clauses supported in ansi-standard sql?

1409

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

Can we create table in function?

1022

what is bcp? When does it used? : Sql dba

1031

What is rowtype?

1081

What are the types of operators available in sql?

1129

What are the types of queries in sql?

1130

What is t sql used for?

1062

How do I make sql search faster?

1044

Why do we need databases?

1093

What is dbo in sql?

1020