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 use of triggers?

978

Can we create table in function?

907

How do I turn a list into a table?

905

What are the main features of cursor?

1038

What are the 3 types of behavioral triggers?

1181

How do I partition in sql?

904

Explain the rollback statement?

961

How can you tell the difference between an index and a view?

869

What is recursive stored procedure?

1045

What is the difference between join and natural join?

881

How to pipe multiline string to isql?

959

How do I delete a trigger?

912

What are the ways on commenting in a pl/sql code?

1051

What is the main reason behind using an index?

964

What is latest version of sql?

982