Question

In an sql query, the _____ wildcard character, used with the like operator, will match multiple unknown characters.

Answer 1

SELECT EMP_NUM, EMP_LNAME, EMP_FNAME, Sum(INV_TOTAL) AS TOTALINVOICES FROM LGINVOICE, LGEMPLOYEE WHERE EMP_NUM = EMPLOYEE_ID GROUP BY EMP_NUM, EMP_LNAME, EMP_FNAME ORDER BY EMP_LNAME, EMP_FNAME