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 / vamsi krishna

this query will give the correct answer.
all the answers which are given above are absolutely wrong.
(take it easy who posted them)
select * from (select rownum as r1,empno,ename,sal,deptno
from emp) where r1=2;
(take default emp table for execution)

Is This Answer Correct ?    12 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the uses of control file.

1050


What is sqlexception in java?

999


How many sectors are in a partition?

1077


What are the dml statements?

1144


Which sorts rows in sql?

1024


what is an extent ? : Sql dba

1105


what are the different index configurations a table can have? : Sql dba

998


Difference between global and parameter variables?

1970


what are the different functions in sorting an array? : Sql dba

1027


how to start mysql server? : Sql dba

1203


Explain what is an index?

1059


Do we need commit after truncate?

1087


What is the primary key?

953


what are the limitations of identity column? : Transact sql

1108


Is clustered index a primary key?

950