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
- 30322 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
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
List some major differences between triggers and stored procedures?
Describe in brief system database.
How to check if a table is being used in sql server?
How do I start sql server agent automatically?
How to start sql server browser service?
Can we add an identity column to decimal datatype?
How to drop an existing schema in ms sql server?
Explain transaction server explicit transaction?
Give an example of why you would want to denormalize a database
Explain what are page splits? : SQL Server Architecture
Can two different columns be merged into single column? Show practically?
What language is sql server written in?
Explain about system stored procedure?
Define views.
