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 clustered vs nonclustered index?

514

What is bit data type?

636

What is query cost in sql server?

564

Explain data warehousing in sql server?

608

What are the different authentication modes in sql server? How can it be changed?

577

What are two difference between sql azure and azure tables?

139

Explain partitioned view?

595

What is the difference between primary key and unique constraints?

520

What is checkpoint in sql server?

627

What are scheduled tasks in sql server?

556

How can sql server instances be hidden?

532

How to update values in a table with update statements in ms sql server?

563

What is tabulation?

566

What it means to be triggered?

510

How to delete duplicate rows from table except one?

553