Multiple SQL Aliases In Single Query MySQL

Question

I have the following query in mysql, and was wondering how I could insert multiple aliases at the same time, any help would be great!

mysql> 
SELECT emp_no,ROUND( AVG(salary), 2),DATE_FORMAT(NOW(),'%m-%d-%Y') AS Today 
FROM salaries 
GROUP BY emp_no 
LIMIT 10;

COLUMN HEADINGS:

| emp_no | ROUND( AVG(salary), 2) | Today      |

I'd like to have something like

| emp_no | avgSal | Today      |

Abhik Chakraborty · Accepted Answer · 2014-04-23 14:48:06Z

3

You have already done it for date, just need to add another one for average salary.

SELECT emp_no,
ROUND( AVG(salary), 2) as avgSal,
DATE_FORMAT(NOW(),'%m-%d-%Y') AS Today 
FROM salaries 
GROUP BY emp_no 
LIMIT 10;

answered Apr 23, 2014 at 14:48

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Note the keyword 'AS' is optional. You can omit it if you want for readability/preference.