wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27297 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
What is exporting and importing utility?
How do you test your database? : sql server database administration
How to locate and take substrings with charindex() and substring() functions?
How to create a simple stored procedure in ms sql server?
what are the three command line utilities and what are their primary functions?
Give main differences between "Truncate" and "Delete".
What are differences in between sql server 2012 and sql server 2016?
How is a full-text index updated?
Write a program to fetch first 10 records from a file?
What do you understand by integration services in sql server?
Difference between group by clause and having clause in SQL?
Explain having clause and where clause?
What is a mixed extent?
Explain cursor as data base object?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
