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

Can we insert in view in sql?

1106


Does truncate need commit?

1005


What is trigger in flip flop?

1063


what is log shipping? : Sql dba

1166


How to run sql statements through the web interface?

1094


What are the types of records?

1038


How can you fetch first 5 characters of the string?

1066


What is group function in sql?

1067


How do you update a sql procedure?

1092


What does desc stand for?

1123


What does plv msg allows you to do?

1179


define sql delete statement ? : Sql dba

1068


What is inner join in sql?

1138


Is id a reserved word in sql?

1187


Is sql a backend?

1073