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 view explain with example?

879

How do I use google cloud in sql?

1026

What is an ndf file?

925

what is timestamp in mysql? : Sql dba

998

What is pl sql in oracle?

988

What is primary and foreign key?

1014

Can %notfound return null after a fetch?

996

Why stored procedure is faster than query?

946

How do I start sql from command line?

961

What are % type and % rowtype?

977

what are all the common sql function? : Sql dba

1009

How to test for null values?

978

What is the difference between sql and mysql?

1050

What are the advantages of sql? Explain

1047

Is left join same as join?

936