select Ename, empno, rn from (select rownum rn, ename, empno from emp) w

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

Question Posted / ajit

Answer Posted / ajit

select Ename, empno, rn
from (select rownum rn, ename, empno
from emp)
where rn between &gno and &gno

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain isolation levels. : Transact sql

1110

What is the purpose of the sql select top clause?

1208

how to convert dates to character strings? : Sql dba

1254

what are enums used for in mysql? : Sql dba

1232

How do you sort in sql?

1071

What is sql integrity?

1249

What is normalisation in sql?

1101

What is the clause we need to add in function body to return variable?

1055

Why select is used in sql?

1070

Can we commit in trigger?

1029

how many ways to get the current time? : Sql dba

1048

Is nosql relational?

1002

What is the difference between a procedure and a function?

1216

How many sql statements are used? Define them.

1081

what is a join? : Sql dba

1086