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

How does a trigger work?

1048

What is substitution variable?

1034

What is the basic form of sql query?

927

How to Execute a Package in PL/SQL.?

1186

How do I partition a table in sql?

1105

List and explain the different types of join clauses supported in ansi-standard sql?

1346

What is the advantage of index in sql?

949

What is bulk compiling in pl/sql.?

1115

Is postgresql a nosql database?

1144

How to take user input in pl sql?

1147

What are character functions in sql?

924

Can we use loop in sql?

961

Is hadoop a nosql?

987

Explain the difference between triggers and constraints?

963

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

960