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

How can get second highest salary in sql?

1025

Why do we use procedures in sql?

1139

What is procedure in pl sql?

1087

What is the size of partition table?

1088

What is full join in sql?

1034

How can a function retun more than one value in oracle with proper example?

1124

Does execute immediate commit?

1289

What is sql query limit?

1020

How to combine two stored procedures in sql?

1324

What are local and global Indexes and where they are useful.

1494

Explain exception handling in pl/sql?

1080

What is coalesce in sql?

1130

What is sql rowcount?

1069

What is parameter substitution in sql?

1079

Describe different types of general function used in sql?

1092