SQL - Keep getting an error Incorrect syntax near the keyword 'AS' -
keep getting error incorrect syntax near keyword 'as'
is there error below?
select avg(salary) [average_salary], concat('$',format( min(salary),2) [minimum_salary], concat('$',format ( max(salary),2) [maximum_salary] salaries (yearid = 1991);
you must close concat
parenthesis:
select avg(salary) [average_salary], concat('$',format( min(salary),2)) [minimum_salary], concat('$',format ( max(salary),2)) [maximum_salary] salaries (yearid = 1991);
Comments
Post a Comment