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...

I want to know last five transactions or records from emp
table, from now?

Answer Posted / sarmistha

select TOP (5) * from emp order by empid desc

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of normalization?

997


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2022


What port does sql server use?

988


Why query optimization is needed?

865


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

978


What are types of joins?

910


What is a behavioral trigger?

932


how many ways to get the current time? : Sql dba

950


What is the default isolation level in sql server? : Transact sql

964


how to enter binary numbers in sql statements? : Sql dba

923


What is pessimistic concurrency control? : Transact sql

1025


What are all types of user defined functions?

1006


What are the differences between in and exists clause?

1050


When sql appeared?

1025


what is the difference between undefined value and null value? : Sql dba

1041