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
Which query will generate the required result?
You want to display 5 percent of the employees with the highest salaries in the
EMPLOYEES table. Which query will generate the required result?
Correct answer is B!
FETCH {FIRST|NEXT} {|NUMBER [PERCENT]} {ROW|ROWS} {ONLY|WITH TIES}
=> The FIRST and NEXT keywords can be used interchangeably and are for semantic
clarity only. Either one must be used.
I agree with shap.
All are Incorrect.
Sorry B is the Correct answer.
B is correct. The sintaxe FETCH need the Keyword FIRST OR NEXT. If you gorget you`ll guve erro 905.