select top 10 (field list) from (tablename) order by (your autonumbering/i

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

Question Posted / mona

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

Please Help Members By Posting Answers For Below Questions

What are the restraints imposed on the table design by a merge replication?

1023

How to modify existing triggers using "alter trigger"?

992

How do I save a stored procedure in sql server?

977

How to change the password of a login name in ms sql server?

1002

What is the size of transaction log file?

911

Can we check locks in database? If so, how can we do this lock check?

929

How would you add a section to a table?

1015

Write a program using SQL queries to find a unique entry in a table.

977

Explain collation?

1052

Define cross join in sql server joins?

1004

What is in place upgrade in sql server?

1028

What is the difference between web edition and business edition?

111

How to create and drop temp table in sql server?

1036

Explain what are page splits? : SQL Server Architecture

1042

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1069