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

How can you check the version of sql server?

1158

What is SQL Azure?

107

How to set database to be single_user in ms sql server?

1080

How to add an address record into adventureworkslt?

1027

How to count rows with the count(*) function in ms sql server?

1059

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1037

Do you know what is lock escalation?

1055

How can you find out which stored procedures are recompiling?

948

How does a profiler work?

993

How to choose all records from the table?

1102

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

985

What is 2nf normalization form?

1200

How many database files are there in sql server 2000?what are they?

1107

Can you roll back the ddl statement in a trigger?

1021

What is updatable resultset?

1072