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

How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com

Regards
Arun

Question Posted / fahad

Answer Posted / fahad

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

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the API of GL,PO,AP

2267

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

2010

8. Supporting AP, AR and GL?

2307

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1170

how to write customizations in po

1618

can u give guidance abt packages of plsql

2174

which one is currently in used software cmpanies.

2151

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

2181

How many segment are present in Oracle Manufacturing

2320

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2399

Is there any link between pr form(purchse requisition)and po form(purchase order)

2721

can we use lexical perameter in oracle plsql if yes how

2313

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

1992

How would you determine who has added a row to a table?

2316

What is the difference between recovery and restoring of the oracle database?

1220