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 use of term?

794

What is cursor in pl sql with examples?

674

What is AUTH_ID and AUTH_USER in pl/sql ?

1942

Will truncate release space?

682

What is the difference between mdf and ndf files?

782

What is the purpose of design view?

730

What is Materialized View? In What Scenario we Use Materialized View?

8946

What are some emotional triggers?

753

what are properties of a transaction? : Sql dba

760

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

873

how to convert character strings to dates? : Sql dba

722

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

728

What is rtm in testing?

766

What is the life of an sql statement?

724

Define concurrency control. : Transact sql

794