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

What is sparse columns of sql server 2008?

1039

what is an extended stored procedure? : Sql server database administration

1046

Can binary strings be used in arithmetical operations?

923

What are user defined functions in ms sql server?

988

How to divide query output into multiple groups with the group by clause in ms sql server?

1023

Explain what is meant by replication of database?

1025

What do we need queues in sql service broker?

1061

Can a rule be bound to any column of any data type?

952

Can foreign key be duplicate?

1051

You want to implement the many-to-many relationship while designing tables. How would you do it?

993

What are joins in sql and what are the different types of joins?

1002

Why functions are used in sql server?

950

What are ddl (data definition language) statements for tables in ms sql server?

1093

What is bcp? When does it used?

972

What is the difference between SQL notification and SQL invalidation?

1171