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 u can find the n row from a table?

Answer Posted / santosh dwivedi

select * from
(
select rownum r,a.* from TableName a
)
where r=n'th

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of index in sql?

995


how would you enter characters as hex numbers? : Sql dba

968


What is sqlca in db2?

936


What is the purpose of primary key?

1003


What is primary key and unique key?

1099


What does plv msg allows you to do?

1122


What is a recursive join sql?

1051


What is count * in sql?

981


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2484


What is an intersect?

1088


What are the different operators available in sql?

987


What is scalar and vector?

987


What is view? Can we update view

1411


What is dynamic sql in pl sql?

1012


How to find 3rd highest salary of an employee from the employee table in sql?

1061