wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / balaji
select * from table_name ORDERBY id DESC limit 0,n;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is scheduled job and how to create it?
what is a check constraint?
What do you mean by data manipulation language?
What is simple indexing method?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How do I know if localdb is running?
What is named calculation? : sql server analysis services, ssas
What are the operating modes in which database mirroring runs?
What are the differences between stored procedure and view in sql server?
What is primary key and example?
What is checkpoint in sql server?
How many types of triggers in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Differentiate between sql temp table vs table variable?
Explain mixed authentication mode of sql server?