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 we can update the view?

1039

Is id a reserved word in sql?

1134

What is the difference between null value, zero, and blank space?

1186

What is the purpose of the sql select top clause?

1088

Why coalesce is used in sql?

982

how to write date and time literals? : Sql dba

946

Is postgresql a nosql database?

1142

Is t sql a programming language?

1049

how to calculate the difference between two dates? : Sql dba

1043

Is a view faster than a stored procedure?

948

Is sqlite good enough for production?

982

How do you rank data in sql?

983

What is varchar example?

1013

What is set transaction?

1019

Why do we use cursors?

976