Answer / chaitanya.s

retrieving 8th record from emp table in scott instance

select * from emp where rownum<=8
minus
select * from emp where rownum<=7

Answer / fahad

select * from emp where rownum<=8
minus
select * from emp where rownum<=7

Answer / shaibya sandeep dwivedi

select id,salary from (select rownum as t,id,salary from
emp) where t=8;

Answer / raj

select * from (select a.*, rownum as n from temp_table a)
where n = 8

Answer / 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

Answer / raam

Hi, above both the answers not worked..

Answer / raj

select rownum,ename,address from emp where rownum=8;

Answer / hitesh rathod

or we can directly use
select * from emp where rownum=8;

What is an Oracle database Full Backup?

0 Answers  

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

0 Answers  

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

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

0 Answers   HCL,

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

How would you force a log switch?

1 Answers  

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

0 Answers   Wipro,

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers