Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in 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
25 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...