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

How do I view tables in sql developer?

935


How do I find duplicates in sql?

929


Why is sql important?

1099


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1064


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1217


Can %notfound return null after a fetch?

1055


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

1177


How do I run a program in pl sql?

1000


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

983


How many joins can you have in sql?

934


What is not null in sql?

1053


What are the advantages of indexing?

982


Why truncate is faster than delete?

1107


What is constant in pl sql?

1016


Is it possible for a table to have more than one foreign key?

1030