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
What is auto invoicing? Explain : oracle accounts receivable
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.
please send me oracle pl/sql exp resume. and also faqs...
can u give guidance abt packages of plsql
as a technical developer in oracle applications which type errors feced in your experience sofar
What is autocashrule set? : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
what is semphore explian it?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Differentiate between transaction type and transaction source? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
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
types of receipts and detail desription about recipts and tables effected by receipts?