Que: What will be the result of the following MySQL command?

SELECT emp_id,
‘ACTIVE’ STATUS,
emp_id * 3.14 emp_pi,
UPPER (lname) last_name
FROM employee;
a. emp_id, ACTIVE, emp_id * 314, UPPER(lname)
b. emp_id, Status, emp_pi, last_name
c. Error
d. None of the mentioned
Answer: emp_id, Status, emp_pi, last_name

Leave a Comment