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 sql trigger example?

1068

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1045

Why procedure is used in sql?

1041

What is %s in sql?

1032

What is sql and also describe types of sql statements?

1067

How do you optimize a stored procedure in sql?

960

Can we use ddl statements in stored procedure sql server?

1013

What is an index in sql with example?

977

What is sql not null constraint?

1042

Is big data nosql?

954

What is a stored procedure in sql with example?

1136

What is delimiter in pl sql?

1064

Which table is left in join?

983

Can a foreign key be a duplicate?

914

Why do we need sharding?

998