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 function and procedure?

1040

What is a system versioned table?

1000

How does stored procedure reduce network traffic?

1020

Is oracle sql free?

995

In what condition is it good to disable a trigger?

1030

what is error ora-03113: end-of-file on communication channel?

1174

What is cross join sql?

926

tell us something about heap tables. : Sql dba

1111

What is the difference between functions, procedures, and packages in pl/sql?

1063

How do I truncate a word?

1102

What is the purpose of the sql select top clause?

1126

How do I create a sql database?

1011

what is sp_pkeys? : Transact sql

1169

How do I clear the screen in sql plus?

1052

Explain clause in sql?

1036