select id,salary from (select rownum as t,id,salary from emp) where t=8;

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

Regards
Arun

Question Posted / shaibya sandeep dwivedi

Answer Posted / shaibya sandeep dwivedi

select id,salary from (select rownum as t,id,salary from
emp) where t=8;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is db_recovery_file_dest in oracle? When do you need to set this value?

1165

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2257

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3643

Why more redos are generated when the oracle database is in begin backup mode?

1169

can u give guidance abt packages of plsql

2238

What is supporting issues GL AP and AR?

2614

What is Restricted Mode of Instance Startup in Oracle?

1231

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

1477

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2281

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

2554

A scenario for amount correction & how to use amount correction functionality in AP invoices

2188

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1089

What is autocashrule set? : oracle accounts receivable

1495

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

2652

8. Supporting AP, AR and GL?

2358