select employee_id,last_name,salary from employees where rownum

how u can find the n row from a table?

Question Posted / monika

Answer Posted / monika

select employee_id,last_name,salary
from employees
where rownum < n
ORDER by salary

Is This Answer Correct ?

0 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is procedure explain with program?

1028

Why is pl sql needed?

959

Is t sql a programming language?

1073

How many primary keys can a table have?

1017

Is delete faster than truncate?

1010

What is difference between stored procedures and application procedures?

1023

what is 'mysqldump'? : Sql dba

1115

What are the triggers associated with image items?

1049

Does mysql_real_escape_string prevent sql injection?

956

What is union, minus and interact commands?

1307

What is set serveroutput on in pl sql?

1308

How can I get the number of records affected by a stored procedure?

1069

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

967

What is information schema in sql?

1078

What is oracle and pl sql?

1125