SELECT * FROM ( SELECT Row_Number() OVER (ORDER BY emp_id, emp

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / bhargav

Answer Posted / bhargav

SELECT * FROM
(
SELECT Row_Number() OVER (ORDER BY emp_id, emp_name) as
emp_name
FROM employees
) as a
where rowid >100 AND rowid<121

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we commit inside a trigger?

977

How do I save a sql query?

1000

How do I save the results of sql query in a file?

961

Can you join a table to itself?

1106

What does pl sql stand for?

1094

Why truncate is used in sql?

980

Explain clause in sql?

1007

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

990

What is file based approach?

924

Mention what are different methods to trace the pl/sql code?

1174

Are stored procedures faster than dynamic sql?

1017

When should I use nosql database?

985

Enlist the characteristics of pl/sql?

1778

What are the types of records?

977

What is 19 null in sql?

934