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

Name few of the dcl commands in sql?

951

What is cached report?

135

What is the difference between Triggers and Stored Procedure?

1031

What is isnull() operator?

976

What is role playing dimension with two examples? : sql server analysis services, ssas

953

What command would you use to create an index?

982

What are the built in functions in sql server?

917

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

937

What does the not null constraint do?

998

Explain what is log shipping?

1073

What causes index fragmentation?

936

What is factless fact table? : sql server analysis services, ssas

963

How to get the definition of a view out of the sql server?

939

What is default constraint?

932

Define Business Edition in SQL Azure?

100