Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dirty read?

1075


What are the differences between local and global temporary tables?

1068


List the various tools available for performance tuning?

883


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1744


What are the different type of replication in sql server?

974


How to create new databases with "create database" statements?

1012


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2053


How do you create an execution plan?

937


A trigger can reference objects outside the current database? State true or false.

999


what's the information that can be stored inside a bit column? : Sql server database administration

1016


What is a join in sql?

1076


How to create a simple stored procedure in ms sql server?

1020


What is snapshot replication?

1042


What is the sql case statement used for?

1087


How to locate and take substrings with charindex() and substring() functions?

1006