Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ?
- 4 Answers
- 10024 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mona
select top 10 (field list) from (tablename) order by (your
autonumbering/identity column) desc
| Is This Answer Correct ? | 5 Yes | 19 No |
Post New Answer View All Answers
What is the difference between sdf and mdf?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Explain how would you store your query in an SSRS report or a Database server?
What are the properties of the relational tables?
What is @@rowcount in sql?
What do you mean by sql server agent?
Can we write ddl in trigger?
Explain the properties of the relational tables?
What is the default order of an order by clause?
What is the order in which the sql query is executed?
How to create and drop temp table in sql server?
How do you improve the performance of a SQL Azure Database?
What is store procedure? How do they work? When do you use?
Why do we use stored procedures in sql server?
Can you name a few encryption mechanisms in sql server?
