You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
FETCH can only be used with FIRST OR NEXT. The syntax is:
FETCH { FIRST | NEXT } [integer-literal | ? ] {ROW | ROWS} ONLY
OFFSET { integer-literal | ? } {ROW | ROWS}
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljoffsetfetch.html