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 to verify the port number of the sql server?

1168

How to grant a permission in ms sql server using "grant execute" statements?

1095

What happens to a trigger with multiple affected rows?

948

How to return the date part only from a sql server datetime datatype?

1107

Explain what is use of dbcc commands?

1060

How do you handle datasets larger than 50 gb?

162

Where is my database stored on the hard disk in ms sql server?

1063

What is sleeping status in sql server?

1027

Explain syntax for disabling triggers?

1046

How to update values in a table with update statements in ms sql server?

1013

How to get nth highest salary from employee table.

1164

Can a cursor be updated? If yes, how you can protect which columns are updated?

1112

What is coalesce and check constraint in sql server?

1122

Explain about nested stored procedure?

1038

Explain the concept of view and Types of views in SQL server?

994