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 / suresh babu

select * from table_name tn1 where 5 = (select count(rowid)
from table_name tn2 where tn1.rowid >= tn2.rowid);

This query,which is display the 5th row in table.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define the select into statement.

1037


What are system versioned tables?

1008


What is compound trigger?

1015


What is the difference between count 1 and count (*) in a sql query?

964


Is sql free?

925


What does (+) mean in sql joins?

1045


Can a foreign key be a duplicate?

895


What is sql and also describe types of sql statements?

1037


what are the nonstandard string types? : Sql dba

1119


Why trigger is used in sql?

950


What is the unique index?

1043


What is difference between inner join and self join?

1068


What is user in sql?

1002


What is a join?

1046


What is data manipulation language?

1171