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
- 29503 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
How you can add messages to the nt event log from within a stored procedure?
What is a unique index?
What is page in sql server?
What are the advantages of sql stored procedure?
Explain what is the use of custom fields in report?
What is a virtual table in sql?
What are the results of running this script?
What is pessimistic concurrency?
Please illustrate physical database architecture? : SQL Server Architecture
What is the maximum size of a dimension? : sql server analysis services, ssas
What is lookup override?
Explain what are various ways to enhance the ssrs report?
What is the contrast amongst drop and truncate?
Why people hate cursor?
Do you know the isolation level that sql server support?
