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 two authentication modes in sql server?

1167

What is function of ROLLUP ?

1137

Why truncate is ddl command?

1109

What is sparse columns of sql server 2008?

1098

Which tcp/ip port does the sql server run on? How can it be changed?

1099

What is awe?

1078

Explain about extended stored procedure?

991

List all the types of user-defined functions?

1178

How to move database physical files in ms sql server?

1093

How to attach adventureworkslt physical files to the server?

1160

What are .mdf files?

1012

What the different components of Replication and what is their use?

1123

What is a document index?

1071

What is an identity?

1076

Explain the truncate command?

1030