SELECT * FROM employees ORDER BY EMPLOYEE_ID OFFSET 99 ROWS FETCH NEXT

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / rutujagabhane

Answer Posted / rutujagabhane

SELECT *
FROM employees
ORDER BY EMPLOYEE_ID
OFFSET 99 ROWS
FETCH NEXT 21 ROWS ONLY;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How show all rows in sql?

1017

Why do we need unique key in a table?

961

what is cross join? : Sql dba

1004

When sql appeared?

1104

how do you control the max size of a heap table? : Sql dba

984

What is difference between group by and partition by?

1066

What are all the different types of indexes?

1152

explain access control lists. : Sql dba

1005

Is sql a scripting language?

1022

What is linq to sql?

1139

What is the use of prepared statement?

1028

Why we use joins in sql?

987

What is the difference between cross join and natural join?

1028

What is on delete set null?

1095

What is sqlca in db2?

974