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 to find 5th row ?

Answer Posted / swastik

SELECT * FROM
          (
           SELECT ROWNUM Rn, E1.*
           FROM Emp
           )
WHERE RN = 5
/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the set operators in sql?

1073


What is primary key sql?

1040


What is mutating trigger?

1024


what happens if you no create privilege in a database? : Sql dba

1001


What is the use of triggers?

1038


Can we insert data in view?

967


What is pl sql commands?

1046


Is left join faster than inner join?

1125


Can we rename a column in the output of sql query?

995


What language is oracle sql developer?

1020


What is the difference between joins?

1041


Explain foreign key in sql?

1026


Which join condition can be specified using on clause?

952


What are the types of records?

988


Why cross join is used?

1078