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

What is set serveroutput on?

1088

Explain 3 basic parts of a trigger.

1256

what are the advantages and disadvantages of views in a database? : Sql dba

996

Does google use sql?

914

How does a trigger work?

990

What types of commands can be executed in sql*plus?

1051

What trigger means?

929

What is primary and foreign key?

1017

How do I order by ascending in sql?

958

Can there be more than one function with a similar name in a pl/sql block?

927

How do you bind variables in pl sql?

1036

what's the difference between a primary key and a unique key? : Sql dba

973

What is difference between hql and native sql?

1093

How do I create a memory optimized filegroup?

906

how can I make a script that can be bi-language (supports english, german)? : Sql dba

945