wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / grace
SELECT TOP 3 * FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY
<COLUMN_NAME> DESC
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
How to specify the collation for a character data type in ms sql server?
Explain about Joins?
query processing
What are various aggregate functions that are available?
Can we hide the definition of a stored procedure from a use?
Difference between Logical Page and Physical Page in SSRS.
How to create new databases with "create database" statements?
What is a subquery in a select query statement in ms sql server?
What are the differences between web role and worker role?
Explain optimistic and pessimistic concurrency?
How check triggers in sql server?
Explain about thread and memory management process of SQL?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What are the two authentication modes in sql server?