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

Can triggers stop a dml statement from executing on a table?

1107

How do you declare a variable in pl sql?

1032

Can we use join in subquery?

1103

How are functions and procedures called in PL/SQL?

1240

How bulk collect improves performance?

1013

What is the use of & in pl sql?

1049

What is a join query?

970

What type of join is sql join?

989

what is the bond code in materialized view?

3005

what is auto increment? : Sql dba

1015

does sql support programming? : Sql dba

1052

Is it possible to pass parameters to triggers?

1107

How to sort the rows in sql.

1080

What are the most important characteristics of pl/sql?

1165

How do I remove sql developer from windows 10?

1118