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

Which is faster subquery or join?

1272

What are literals in sql server?

1259

What is a recursive join sql?

1116

what are the performance and scalability characteristics of mysql? : Sql dba

1034

Are sql database names case sensitive?

1052

What is 19 null in sql?

1021

Is delete faster than truncate?

1052

What is a schema sql?

1227

How do you go back in sql?

1029

Write a query to find the names of users that begin with "um" in sql?

1045

how to enter characters as hex numbers? : Sql dba

1103

Why is partition used in sql?

1183

What is the difference between count 1 and count (*) in a sql query?

1055

Can we use pl sql in sql server?

1136

What are the dml statements?

1196