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;

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

For web applications from which version of Oracle is suitable?

1 Answers  

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

What is mrc and what is its use? : oracle accounts receivable

0 Answers  

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers  

How can you rebuild an index?

1 Answers  

Explain materialized views and how they are used.

2 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,

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers