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

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2512

What is auto invoicing? : oracle accounts receivable

1238

what are basic modules required to implement oracle application in any oraganisation?

2259

What is Restricted Mode of Instance Startup in Oracle?

1234

What is auto invoicing? Explain : oracle accounts receivable

1171

How would you go about increasing the buffer cache hit ratio?

2656

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1330

key flexfield structure

2233

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

1866

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

1153

What is the use of lockboxes? : oracle accounts receivable

1263

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

2074

What is Tax Categories?

2162

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

Difference between negative and positive adjustments : oracle accounts receivable

1163