Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 29679 Views
- I also Faced
- E-Mail Answers
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 does <> symbol mean?
How you can add messages to the nt event log from within a stored procedure?
What is constraints and its types?
How to return the date part only from a sql server datetime datatype?
How to transfer a table from one schema to another?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the process of normalization?
How to create user defined functions with parameters?
Explain indexes disadvantages?
Explain what is the main purpose of having conversation group?
can SSRS reports Cache results?
How to filter out duplications in the returning rows in ms sql server?
What is the difference between Clustered and Non-Clustered Index?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
