Exam 1z0-071 topic 1 question 231 discussion

With Ties - Query would have returned one more row with an equal salary to the last row's salary if that salary number matches. In this case, it didn't so it returns 5 rows only.

A tested. However, what is the meaning of WITH TIES then. If replacing with ONLY returns the same result.

The WITH TIES returns additional rows with the same sort key as the LAST row fetched.

A is correct

Option A tested in DB. If the salary contain like the below example: id Salary 1 12000 2 15000 3 16000 4 16000 5 17000 in this case, with ties option return extra rows select id,salary from emp order by salary fetch first 3 rows with ties; o/p: 1 12000 2 15000 3 16000 4 16000

A tested. CREATE TABLE EMP ( ID NUMBER(10), NAME VARCHAR2(10), SALARY NUMBER(10) ) INSERT INTO EMP VALUES (101, 'JOHN', 26000); INSERT INTO EMP VALUES (102, 'NEENA', 24000); INSERT INTO EMP VALUES (103, 'DEHAAN', 12000); INSERT INTO EMP VALUES (104, 'LEX', 17000); INSERT INTO EMP VALUES (105, 'BILL', 18000); INSERT INTO EMP VALUES (106, 'DANIEL', 26000); INSERT INTO EMP VALUES (107, 'BEN', 12000); INSERT INTO EMP VALUES (108, 'GEORGE', 25000); SELECT * FROM EMP ORDER BY SALARY FETCH FIRST 5 ROWS WITH TIES;

A tested

A is correct, checked in DB