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 the difference between union and union all command?

1059

How to run sql*plus commands in sql developer?

1131

Can you skip header records while loading? : aql loader

1018

What is bitemporal narrowing?

1284

what is a materialized view? : Sql dba

1045

What is multiple partition?

950

How to create an array in pl/sql?

1052

What company owns postgresql?

1003

What is the unique index?

1043

what is primary key? : Sql dba

1008

What is the process of copying data from table a to table b?

1079

what are all the different normalizations? : Sql dba

1015

What is the difference between execution of triggers and stored procedures?

1098

What is clause?

1126

What is the use of <> sql?

959