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 stored procedure and view?

1067

Is postgresql a server?

1114

What is the purpose of normalization?

1088

How do you pronounce sql?

1062

is it possible to pass an object or table to a procedure as an argument?

1179

What are stuff and replace function?

1143

Explain the difference between sql and mysql.

1113

How to run sql*plus commands in sql developer?

1207

Why sql query is slow?

1044

What is percent sign in sql?

1328

How do I run a sql query in pgadmin 4?

1002

What is bitemporal narrowing?

1370

Why is a primary key important?

1105

what are all different types of collation sensitivity? : Sql dba

1031

What is materialized view. What are different methods of refresh?

1443