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
- 29831 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan k. dubey
1-select * from employee where emp_id >(select count(*)-3
from employee)
2-select * from employee where emp_id in
(
select top 3 emp_id from employee order by emp_id DESC
)
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What do you think of this implementation? Can this be implemented better?
What is a covering index?
Can we linked SharePoint to a SQL database?
can you implement data mining in SSRS?
What is normalization of database?
How to provide default values to function parameters?
Do you know what are different types of replication in sql server?
Explain rdbms?
What is the difference between web edition and business edition?
What is the latest version of microsoft sql server?
What happens to a trigger with multiple affected rows?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is bcp? When does it use?
What are scheduled tasks in sql server?
How you can move data or databases between servers and databases in sql server?
