How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun
- 8 Answers
- 11336 Views
- I also Faced
- E-Mail Answers
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
