select * from emp where rownum>101 and rownum<121

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

Question Posted / intelligent

Answer Posted / intelligent

Is This Answer Correct ?

2 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is the use of index in hive?

963

How do I turn a list into a table?

909

What does select top 1 do in sql?

1007

What is data definition language?

1048

What are the sql aggregate functions?

1068

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901

What is a left inner join?

948

What is rownum and rowid?

985

What is offset and limit in sql?

1002

Does sql view stored data?

900

What are aggregate functions in sql?

1090

What are all the different types of indexes?

1092

Can we join more than 2 tables in sql?

950

How do I run a sql query in pgadmin 4?

906

Can a foreign key be a duplicate?

858