wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27299 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishna sandeep
select top 3 <column_name> from ,table_name> order by
<column_name> desc
this will work.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain mixed authentication mode of sql server?
How do I find the query plan in sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
A trigger can reference objects outside the current database? State true or false.
Explain go command in sql server?
Where sql server usernames and passwords are stored in a sql server?
explain declarative management framework (dmf) in sql server 2008?
What purpose does the model database server?
In case you have filters in your report, when filters will be applied in cached report instance?
Can we return Data from 4(more than 1) tables in stored procedure?
What do you understand by recursive stored procedure?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Delete duplicate rows without using rowid.
How to make a remote connection in a database?
What is updatable resultset?
