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
- 29230 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 are the differences between lost updates and uncommitted dependencies?
How can I get data from a database on another server?
Who is the owner of a schema in ms sql server?
What are the differences between stored procedure and view in sql server?
How do I find information about the install locations for the various instances running on a computer?
What is the default value of an integer data type in sql server 2005?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How to create a view using data from another view?
What are subquery and its properties?
How do I create a trace in sql server?
What are types of scd? : sql server analysis services, ssas
Write SQL queries on Self Join and Inner Join.
Can we do dml on views?
How to use subqueries with the exists operators in ms sql server?
What is postgresql server?
