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 is transaction server explicit transaction?

751

what are cursors? : Sql server database administration

727

What is meant by datasource?

687

Introduction of rollup clause using sum and group by clause?

709

Explain what are the authentication modes in sql server?

684

What is database replication?

761

What are dml (data manipulation language) statements in ms sql server?

740

How to create a large table with random data for index testing in ms sql server?

745

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

721

Write a sql query to sort on different column name according to the parameters passed in the function?

699

Explain isolation levels that sql server supports?

767

What is extent? Types of extents?

793

What are the different types of normalization?

818

What are the methods used to protect against sql injection attack?

808

Explain encryption of entire databases without the need for application changes in sql server 2008?

774