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

What is the difference between inner join and left join?

735

How do I copy a table in sql?

696

What is full form of rtm?

723

Can we group by two columns in sql?

729

What is time based sql injection?

688

How do I count rows in sql?

739

What is Collation Sensitivity ? What are the various type ?

697

Can we use view in stored procedure?

700

what are myisam tables? : Sql dba

721

What are the basic techniques of indexing?

780

What is sql not null constraint?

775

What is dml and ddl?

713

Do prepared statements prevent sql injection?

691

How to Declare Fixed Length String Value In PL SQL

843

What do you understand by exception handling in pl/sql?

760