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 / sandhya rani

This is perfect answer...
and do not misguide the ppl by simply writing wrong answer.
until and unless u r perfect..pls do not share your answer


select * from emp where rownum<=2
minus
select * from emp where rownum<2

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the starting oracle error number?

1051


what is sql in mysql? : Sql dba

1185


List out the acid properties and explain?

949


what is sub-query? : Transact sql

1097


What is sql stand for?

979


Can we use two order by clause in query?

967


how would you get the current date in mysql? : Sql dba

967


Why do we use partitions in sql?

1044


When do we use triggers?

1074


What are the different sql languages?

1033


how do you login to mysql using unix shell? : Sql dba

1079


What is the trigger in sql?

947


Is sql between inclusive?

1124


What is the difference between instead of trigger and after trigger?

1007


Is foreign key mandatory?

998