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
- 29681 Views
- I also Faced
- E-Mail Answers
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 catalog views?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is a virtual table in sql?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What are different types of roles provided by ssrs?
Can two tables have the same primary key?
How to add additional conditions in SQL?
What is a periodical index?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How do I schedule a sql server profiler trace?
How to how to convert numeric expression data types using the convert() function??
What is merge join?
What xml support does the sql server extend?
What samples and sample databases are provided by microsoft?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
