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

Does sql profiler affect performance?

942

What are the benefits of triggers?

1122

What does inner join mean?

1064

how can we find the number of rows in a table using mysql? : Sql dba

1031

How to Declare Fixed Length String Value In PL SQL

1104

How are sql commands classified?

1038

Explain the difference between drop and truncate commands in sql?

965

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

949

What is the difference between a query and a report?

904

What normalization means?

907

What does count (*) do in sql?

954

Explain the advantages and disadvantages of stored procedure?

1078

How do you create a db file?

959

What are different types of functions in sql?

959

Which type of cursor is used to execute the dml statement?

896