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 are the authentication modes in sql server? : Sql dba

547

Explain commit, rollback and savepoint.

617

How to run pl sql program in mysql?

524

How do you exit in sql?

604

What is the purpose of the primary key?

578

how can we know the number of days between two given dates using mysql? : Sql dba

556

What are the different schemas objects that can be created using pl/sql?

542

Is it possible to create startup or shutdown trigger for on-schema?

595

which tcp/ip port does sql server run on? : Sql dba

525

What is Histogram?

1111

What is anonymous block in sql?

650

What are system versioned tables?

559

what is uncommittable transactions? : Transact sql

577

What is a heap in sql?

533

What is difference between primary and secondary key?

528