Select *,row_number over(partition by departmentid order by empid)as rowid

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

Question Posted / anjana

Answer Posted / anjana

Select *,row_number over(partition by departmentid order by empid)as rowid from employeeDept
where rowid between 100 and 120

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is data manipulation language?

880

How to use sql*plus built-in timers?

768

what is foreign key? : Sql dba

753

Is id a reserved word in sql?

860

How can you create an empty table from an existing table?

799

How do you take the union of two tables in sql?

731

Mention what does plv msg allows you to do?

855

What is on delete set null?

765

Can we rollback delete command?

695

What does pragma mean?

713

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

8939

How do I delete a trigger?

723

What is the use of function in sql?

732

What are pl/sql packages?

765

How do temporal tables work?

692