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

explain what is mysql? : Sql dba

600

What can I use instead of union in sql?

518

What is a call statement? Explain with an example.

551

How do I run sql?

622

How do I quit sql?

502

what's the difference between a primary key and a unique key? : Sql dba

510

What are the different types of database management systems?

532

What is the difference between inner join and left join?

547

how to calculate expressions with sql statements? : Sql dba

532

What is difference between procedure and trigger?

519

What does where 1 1 mean in sql?

548

How to use sql statements in pl/sql?

581

Is sql free?

501

What is raid? How does it help storage of databases?

603

What is an exception in pl/sql?

544