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

Can there be more than one function with a similar name in a pl/sql block?

1041


What is $$ in sql?

1045


What are the various restrictions imposed on view in terms of dml?

1017


Can a composite key be null?

1034


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2611


what are integrity rules?

1092


what is dbms? : Sql dba

1036


What is the mutating table and constraining table?

1082


What is trigger in flip flop?

1063


Why do we use triggers?

1017


What is compilation error in pl sql?

1025


What does trigger mean in slang?

1123


What are the most important ddl statements in sql?

1188


How many scalar data types are supported in pl/sql?

1105


What is latest version of sql?

1102