SELECT EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID FROM (SELECT ROWNUM R,EMPLOYEE

how u can find the n row from a table?

Question Posted / vijayshanker

Answer Posted / vijayshanker

SELECT EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the source code of a program?

507

Which table is left in join?

516

What is cost in sql execution plan?

490

Explain clause in sql?

564

What is set transaction?

582

How do I use google cloud in sql?

539

Why we use pl sql?

529

What does bitemporal mean?

597

how can you create an empty table from an existing table? : Sql dba

659

What is difference between ms sql and mysql?

476

How does one use sql*loader to load images, sound clips and documents? : aql loader

671

Is there a 64 bit version of ssms?

518

What is sql deadlock?

565

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2005

what is heap table? : Sql dba

610