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
- 30290 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
select top 3 from <table name > where < specify any
condition> order by <column ID> desc
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
How do you create a data source?
What is use of except clause? How it differs from not in clause?
When cursors are useful?
Why olap is used?
How do I create a trace in sql server?
how can u get last observation in an unknown dataset ?
Explain the properties of a relational table?
How to get the definition of a user defined function back?
Explain four layers of abstraction microsoft architectured?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What are cursors stored procedures and triggers?
Tell me what are the advantages of using stored procedures?
How does clustered and non clustered index work?
What are the disadvantages of using the stored procedures?
What is updatable resultset?
