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 blind sql injection?

1169

Which is faster count (*) or count 1?

1089

Can we commit inside a trigger?

1048

what is a trigger? : Sql dba

1095

What are the differences between in and exists clause?

1170

What are the possible values that can be stored in a boolean data field?

1043

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1149

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1288

What jobs use sql?

1033

What are stored procedures in mysql?

1076

what is the use of friend function? : Sql dba

1063

What are pl sql procedures?

1081

which operator is used in query for pattern matching? : Sql dba

1046

Will truncate release space?

992

What are different types of indexes?

1058