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 find 5th row ?

Answer Posted / alok narayan

1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can function return multiple values in sql?

1098


What is the current version of sql?

1070


Which is faster truncate or drop?

1102


What is autocommit sql?

1044


How can a function retun more than one value in oracle with proper example?

1129


How can we optimize a sql query?

1109


Can we edit a view in sql?

1047


What is a string data type in sql?

1102


what is user defined functions? : Sql dba

1086


How to handle bulk data?

1368


Which is better join or inner query?

1127


what tools available for managing mysql server? : Sql dba

1132


What is synonyms?

1120


Is a foreign key always unique?

984


Show code of a cursor for loop.

1113