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 triggers and its uses?

595

Which command is used to call a stored procedure?

505

How many joins can you have in sql?

524

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6088

What is keys and its types?

546

What is the difference between database trigger and stored procedure?

558

how to use case expression? : Sql dba

556

Which data dictionary views have the information on the triggers that are available in the database?

756

is mysql query is case sensitive? : Sql dba

566

What are different types of statements supported by sql?

610

Is sqlite free?

542

Is sqlite thread safe?

609

What is difference between sql function and stored procedure?

508

Can a view be mutating? If yes, then how?

581

What is cost in sql execution plan?

491