You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?
//IMG//
- A.Option A
- B.Option B
- C.Option C
- D.Option D B
oracle · 1z0-061 · Q604 · multiple_choice · topic_1
You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table. Which query will gener…
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}
Reference:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljoffsetfetch.html
Reference: examtopics_answer_description
Practice with progress tracking
Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.