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

Write a unique difference between a function and a stored procedure.

1053

Is sql an operating system?

1073

Can we use pl sql in mysql?

1063

Is sql considered coding?

1088

What is the use of procedures?

1015

Does varchar need length?

1048

Can we use ddl statements in stored procedure?

1191

What are keys in sql?

1040

How can a function retun more than one value in oracle with proper example?

1124

Which is better varchar or nvarchar?

1050

What is the max nvarchar size?

1028

Is vs as in pl sql?

1037

How to get each name only once from an employee table?

1159

What is an emotional trigger?

1057

How to revise and re-run the last sql command?

1218