wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / vijaykumar dolli
Select * From Sample Where
Srno In (Select Top 3 srno From Sample Order By 1 Desc)
-- Sample is a Table Name and Srno is Unique Key column
-- This is the perfect Answer ...!
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the components of dbms?
What are character string data types in ms sql server?
How to create dbo table in sql server?
Introduction of rollup clause using sum and group by clause?
what are different types of backups available in sql server? : Sql server database administration
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
List some of the rules that apply to creating and using a ‘view’
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
what are user defined datatypes? : Sql server database administration
What is sql server programming?
What is application role in sql server database security? : sql server security
What are the types of sql server?
Does any body please help me what question's have asked for SSRS in the interview?
What are indexers?
What command do we use to rename a database?