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 a natural join?

1075

What is primary key and unique key?

1121

What is scalar data type in pl sql?

1074

What is left join in postgresql?

1051

Can a view be mutating? If yes, then how?

1028

where are cookies actually stored on the hard disk? : Sql dba

1031

How do you create a unique index?

1051

Which table is left in join?

983

What is cursor in pl sql?

1120

What is union, minus and interact commands?

1300

Enlist the data types that can be used in pl/sql?

1073

What are triggers and its uses?

1050

what does it mean to have quoted_identifier on? : Sql dba

1146

How do I filter in sql profiler?

999

How do you modify a column in sql?

1000