select * from (select a.*, rownum as n from temp

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

Regards
Arun

Question Posted / raj

Answer Posted / raj

select * from (select a.*, rownum as n from temp_table a)
where n = 8

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of table functions.

2378

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1967

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1196

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1309

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1258

Difference between negative and positive adjustments : oracle accounts receivable

1012

What is auto invoicing? : oracle accounts receivable

1085

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2276

key flexfield structure

2111

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

1099

How do you create a credit note against an invoice? : oracle accounts receivable

1023

what are the API of GL,PO,AP

2215

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1063

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2013

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1137