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 retrive only second row from table?

Answer Posted / amit kumar (patna)

select * from
( select rownum rn, job_ticket_mst.* from job_ticket_mst where rownum<=2)
where rn=2

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert comma separated string to array in pl/sql?

1177


what are all the common sql function? : Sql dba

1057


Why indexing is needed?

981


What is using in sql?

1086


Is record in oracle pl sql?

958


What is the difference between sql and t sql?

1031


Is left join inner or outer by default?

1017


What is asqueryable?

965


What is procedure function?

1050


Explain the structure of pl/sql in brief.

1091


What is a parameter query?

1076


How do you exit in sql?

1106


Can ddl statements be used in pl/sql?

1140


Why is pl sql needed?

930


Why do we use sql constraints? Which constraints we can use while creating database in sql?

1040