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 / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<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 primary key in db?

1008


What operating systems are supported by oracle sql developer?

965


Why plvtab is considered as the easiest way to access the pl/sql table?

1216


what is a cursor? : Sql dba

1023


What is index example?

1008


What are the disadvantages of not performing database normalization?

1165


What is fmtonly in sql?

1085


What is trigger in pl sql with examples?

1041


What is the limitation on the block size of pl/sql?

987


What is minus?

1000


What is forward declaration in pl sql?

1077


Can cursors be part of a trigger body?

1641


What happens when a trigger is associated to a view?

914


What is a record in a database?

1062


How many types of triggers exist in pl/sql?

1072