select top 10(fieds_name) from <table_name> order by (fields)name)

What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ?

Question Posted / anand

Answer Posted / anand

select top 10(fieds_name) from <table_name> order by
(fields)name) desc.

Is This Answer Correct ?

2 Yes

14 No

Please Help Members By Posting Answers For Below Questions

How can we improve performance by using SQL Server profiler?

1058

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What is coalesce and check constraint in sql server?

1123

What is transaction server isolation?

1045

What is the main purpose of having conversation group?

900

Explain what are the events recorded in a transaction log?

1008

What does the on delete cascade option do?

1019

What are the essential components of sql server service broker?

1020

What are the general features of sql server management studio? : sql server management studio

1087

What is difference between cte and view?

924

Which sql server table is used to hold the stored procedure script?

952

How to sort the query output with order by clauses in ms sql server?

1035

What is the difference between online clustering and Offline clustering?

2419

Describe triggers features and limitations?

993

What is the report model project?

142