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

How do you retrieve the last N records from a table?

Answer Posted / swastik

 select
 * from
 (
 select  e1.*
 from emp e1
 order by rownum desc
 )
 where rownum <= &n

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I kill a query in postgresql?

1072


Can we insert data in view?

947


What are the types of triggers in sql?

1065


what is bcp? When is it used?

1091


What is set transaction?

1018


What is form and report?

960


What is the left table in sql?

952


What are the different ddl commands in sql?

1131


Describe sql comments?

1011


Why we use cross join?

937


Write the alter statement to enable all the triggers on the t.students table.

1110


Why do you partition data?

1006


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1044


In pl/sql, what is bulk binding, and when/how would it help performance?

981


What is offset in sql query?

1092