Versions Compared

Version Old Version 2 New Version Current
Changes made by

Vaishnavi Sridhar

Vaishnavi Sridhar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

And the actual query with Paging is done like -

Code Block
languagesql
Query with paging 
SELECT 
EMP_ID, EMP_NAME, EMP_AGE
FROM
EMPLOYEES
WHERE
<COL 1> like '%filter%' –- and so on
AND ROWNUM < endRowOfPage and ROWNUM > startRowOfPage
ORDER BY
<COL1> ASC, <COL 2> DESC –- and so on

...