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

Where in the Oracle directory tree structure are audit traces placed?

2647

Could you please let me know the interfaces in OM / FA??

2276

What is the use of lockboxes? : oracle accounts receivable

1221

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2223

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

2008

which one is currently in used software cmpanies.

2165

What is supporting issues GL AP and AR?

2571

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7692

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

2411

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2112

how to replace not in with not exist?

3748

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1361

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2086

What is the disk migration? what is the steps involved in oracle disk migration?

1234

Explain the payment term in ar. : oracle accounts receivable

1117