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;

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

What type of index should you use on a fact table?

1 Answers  

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

What is the importance of batch source set up in ar? : oracle accounts receivable

0 Answers  

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

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.

0 Answers   Accenture,

can u give guidance abt packages of plsql

0 Answers   Mphasis,

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

can we use lexical perameter in oracle plsql if yes how

0 Answers