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

What is a unique key and primary key and foreign key?

1022


What are different joins used in sql?

1107


Mention what problem one might face while writing log information to a data-base table in pl/sql?

1287


What are the advantages of sql?

1100


Can you inner join the same table?

1039


Where is all the data on the internet stored?

1057


What are the sql versions?

1000


What is assignment operator in pl sql?

1087


what is the difference between clustered and non clustered index in sql? : Sql dba

1190


How do you rename a table in sql?

1186


What is sorting in sql?

985


What is output spooling in sql*plus?

1092


Can we group by two columns in sql?

1046


Can you have a foreign key without a primary key?

1000


Do we need to rebuild index after truncate?

1098