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 to create a new login name in ms sql server?

1043

How to enter comments in transact-sql statements?

925

what are the reporting service components in SSRS?

163

What is Command line parameters in PLSQL.?

1110

How to set database to be single_user in ms sql server?

1010

What are different replication agents and what's their purpose? : sql server replication

994

Explain the disadvantages of cursors?

1120

How you provide security to cube? : sql server analysis services, ssas

951

What is a join in sql? What are the types of joins?

1073

What is indexed view? How to create it?

970

What is the command dbcc checkdb used for?

995

What are the new data types are introduced in sql 2000?

888

Why do we need different type of parameter?

1039

How to change the system date and time from SQL Plus Terminal ?

1200

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1987