select * from employees where rownum between 100 and 120

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Question Posted / sum

Answer Posted / sum

Is This Answer Correct ?

2 Yes

15 No

Please Help Members By Posting Answers For Below Questions

Are stored procedures compiled?

899

What is the plv (pl/vision) package offers?

1029

What is a pdo connection?

1008

how to see the create table statement of an existing table? : Sql dba

987

What are sql functions? Describe in brief different types of sql functions?

1076

what is csv? : Sql dba

983

What is multiple partition?

952

How do you modify a trigger?

914

What is data type in sql?

941

What are the different sql languages?

1022

What is t sql used for?

1005

What is group function in sql?

1002

How do you declare a user-defined exception?

1005

What is a data manipulation language?

1007

what is bcp? When does it used? : Sql dba

974