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

Why procedure is used in sql?

1041


What is sql engine in oracle?

994


Why do we need cursor in pl sql?

1138


What is partition by in sql?

1070


what is a trigger? : Sql dba

1033


What is an inconsistent dependency?

1051


What is difference between joins and union?

1129


What is union?

1174


Write a query to find the names of users that begin with "um" in sql?

998


Can we call dml statement in function?

1061


How can you view the errors encountered in a trigger?

962


What are all the different normalizations?

1036


what are the limitations of identity column? : Transact sql

1108


Is drop table faster than truncate?

991


Is sql an operating system?

1021