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 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com

Regards
Arun

Answer Posted / sandeep

syntax: select <rownum>,<c.. n.. 2>,<c..n..3>
from<tablename>
group by<rownum>,<c.n.2>,<c.n.3>
having rownum=&n
eg:
select rownum,ename,empno from emp
group by rownum,ename,empno
having rownum=&8

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is auto invoicing? Explain : oracle accounts receivable

1052


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2431


please send me oracle pl/sql exp resume. and also faqs...

2443


can u give guidance abt packages of plsql

2104


as a technical developer in oracle applications which type errors feced in your experience sofar

2272


What is autocashrule set? : oracle accounts receivable

1289


Explain how to close periods in ar. : oracle accounts receivable

1231


What do you mean by Oracle MEDIA RECOVERY?

1159


what is semphore explian it?

2734


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2219


Differentiate between transaction type and transaction source? : oracle accounts receivable

1063


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2140


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1071


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17489


types of receipts and detail desription about recipts and tables effected by receipts?

2011