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 trigger explain with example?

1092


what is the difference between group by and order by in sql? : Sql dba

1188


How to assign sql query results to pl sql variables?

1146


How can you create an empty table from an existing table?

1128


What is primary and foreign key?

1123


difference between anonymous blocks and sub-programs.

1188


what is a foreign key ? : Sql dba

1115


How do I write a cron which will run a sql query and mail the results to agroup?

1031


how many triggers are allowed in mysql table? : Sql dba

1103


what is timestamp in mysql? : Sql dba

1132


Explain what is rdbms?

1086


What is mutating error?

1007


how many tables will create when we create table, what are they? : Sql dba

1118


what is a field in a database ? : Sql dba

1099


What is package in pl sql with an examples?

1087