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 do I start sql server?

923

What is sql server profiler?

951

Explain timestamp datatype?

906

How use inner join in sql server?

1051

What are the purpose of Normalisation?

998

Explain a join?

1002

What are different backups available in sql server?

994

What are the two modes of authentication in sql server?

976

How can we use ConnectorJ JDBC Driver with MS SQL?

947

What is resultset concur_updatable?

966

Define tempdb database?

937

How can i Relate Tables in SSIS

1032

explain the storage models of olap? : Sql server database administration

879

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

910

List out some of the requirements to set up a sql server failover cluster?

973