Which three statements are true about single-row functions?
Examine this statement:
SELECT 1 AS id, ' John' AS first name
FROM DUAL
UNION
SELECT 1 , ' John' AS name
FROM DUAL
ORDER BY 1;
What is returned upon execution?
Examine the description of the EMPLOYEES table:
Which statement will execute successfully, returning distinct employees with non-null first names?
The STORES table has a column START_ DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_ DATE is within the last 25 months.
Which WHERE clause can be used?
Examine the description of the PRODUCT_ DETAILS table:
Which two statements are true?