Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN "˜000020' and "˜000070'
Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > "˜000020' AND empno "˜000070'
The query asks for the number of rows where the employee number (empno) is greater than 000020 and less than 000070. From the given result set, the employee numbers between 000020 and 000070 are 000030, 000050, and 000060. Therefore, the query would return 3 rows.
The SQL has syntax error wrt answer : C Correct SQL: SELECT empno FROM emp WHERE empno > "˜000020' AND empno < "˜000070'
Yes syntax error, answer should be "C" typo error.