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

wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records

Question Posted / nitesh srivastava

Answer Posted / nitesh srivastava

select * from emp
minus
select * from emp where rownum<(select count(*)-2 from emp)

Is This Answer Correct ?

8 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What stored by the master?

949

How you can find out if an index is useful to the optimizer?

938

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

What is apply operator in sql?

1010

Explain various On-Delete options in a DB table. Which is the default option?

1466

How do I completely remove sql server instance?

1099

Differentiate sql server reporting services vs. Crystal reports?

200

How can you manage sql azure security?

101

Explain trigger classes i.e. Instead of and after trigger?

877

What is subquery in sql?

1065

Name some of the open source software that you can use in alternative to SSR?

161

What is a file group?

1089

How to create a simple table to test triggers in ms sql server?

975

Is mysql better than sql server?

1059

How to set the current database in ms sql server?

1078