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 is the main purpose of having conversation group?
How to convert numeric expression data types using the cast() function?
What is mssql?
What do you understand by recursive stored procedures?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain tables in SQL Azure?
Give me any three differences between Truncate and Delete.
Why normalization is used?
What are the security related catalog views? : sql server security
What is the syntax to execute the sys.dm_db_missing_index_details?
Tell me the difference between clustered and non-clustered index?
What are the main sources of data?
How to skip remaining statements in a loop block using continue statements?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How many joins in sql server?