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

i have some prob lem to tell me about my self in interview first round ...

1690

What is the use of pl/sql table?

544

How to read/write files from pl/sql?

572

What is the clause we need to add in function body to return variable?

530

What is a primary key sql?

552

What is parameter substitution in sql?

514

Can we update views in sql?

523

What are character functions?

620

Can we use loop in sql?

524

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

518

Explain locks? : Transact sql

559

Do we need to create index on primary key?

457

What is the function that is used to transfer a pl/sql table log to a database table?

540

How to rename a column in the output of sql query?

526

What is a unique key and primary key and foreign key?

556