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 the difference between getdate and sysdatetime?

1060

What is difference between clustered index and non clustered index?

1120

How to loop through returning rows?

1086

What structure can you implement for the database to speed up table reads?

1232

What are data regions?

140

Tell me what are the essential components of sql server service broker?

986

Tell me what is the stuff and how does it differ from the replace function?

1034

Define left outer join in sql server joins?

1008

What is instead of trigger sql server?

1074

What factors you will consider calculating the storage requirement for that view?

990

What is the ‘fillfactor’?

1013

Do you know clustered and non-clustered index?

1019

What are the filtered indexes?

1091

What is sub query and its properties?

1024

How you would rewrite the sql query to return the customerid sorted numerically?

1043