questions - Question:The EMP table contains the following columns: EMPNO NUMBER(6) HIREDATE DATE Review the following SELECT statement: SELECT empno, TO_DATE('31-DEC-99') - hiredate FROM emp WHERE hiredate BETWEEN '31-DEC-00' AND '31-DEC-01'; What are the results of this statement?

a.        The employee numbers of any employees hired on January 1, 2001 are displayed
b.        Date and numeric values are returned
c.        Only numeric values are returned
d.        The employee numbers of all employees hired before the year 2001 are displayed
e.        Only the employee numbers of all employees are displayed because the BETWEEN operator used in the WHERE clause condition is a number function

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.