wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
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 are the difference between primary key and unique key? : sql server database administration
Can you explain full-text query in sql server?
How retrieve field names from the table in SQL through JAVA code?
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 list all dsn entries on your local machine using odbc_data_source()?
What is query optimizer in sql server?
Do you know the capabilities of cursors?
Differentiate between SQL and ORACLE joins and write their syntax.
What is @@rowcount in sql?
What is difference between index seek vs. Index scan?
What is a non equi join?
How to defragment indexes with alter index ... Reorganize?
when would you go for denormalization? : Sql server database administration
Why is sql server log file full?
Explain the phases a transaction has to undergo?