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
- 30323 Views
- I also Faced
- E-Mail Answers
Answer Posted / bobby
select * from table_name where <Primary key Column-
name> != all
(select top (@@rowcount-3) <Primary key Column-name> from
Table_name)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the meaning of sql server?
How you can get the list of largest tables in a database?
Why do you need a sql server?
How we can refresh the view?
What are the advantages of sql stored procedure?
Define Wed Edition in SQL Azure?
How to create a view on an existing table in ms sql server?
Can you index views?
Explain activity monitors
Explain different forms of normalization?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is a field name?
how would you improve etl (extract, transform, load) throughput?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is the chart in report?
