Oracle Database 12c SQL 1z0-071 Question # 29 Topic 3 Discussion

Oracle Database 12c SQL 1z0-071 Question # 29 Topic 3 Discussion

1z0-071 Exam Topic 3 Question 29 Discussion:
Question #: 29
Topic #: 3

Which two statements will return the names of the three employees with the lowest salaries?


A.

SELECT last_name, salary

FROM employees

WHERE ROWNUM<=3


B.

SELECT last_name,salary

FROM employees

ORDER BY salary

FETCH FIRST 3 ROWS ONLY;


C.

SELECT last_name,salary

FROM employees

WHERE ROWNUM<=3

ORDER BY (SELECT salary FROM employees);


D.

SELECT last_name,salary

FROM (SELECT * FROM employees ORDER BY salary)


E.

SELECT last_name,salary

FROM employees

FETCH FIRST 3 ROWS ONLY

ORDER BY salary;


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.