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 CARTESIAN PRODUCT?

2 Answers  

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

0 Answers  

What command would you use to encrypt a PL/SQL application?

1 Answers  

How do you resize a data file?

2 Answers  

How do you use trigger to create mutating state of table

2 Answers   TCS,

What is the sql query to find the employee who has Nth maximum salary?

2 Answers  

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

0 Answers  

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

What command would you use to create a backup control file?

1 Answers  

3. Steps in UAT?

0 Answers   Oracle,

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers