sql query to display deptname and other stuff but giving right paranthesis
error
select d.dname ,
d.loc ,
count(e.deptno),
round(avg(e.sal),2) as "Salary"
from dept d, emp e
where d.deptno = e.deptno
group by d.dname, d.loc, e.deptno;
No comments:
Post a Comment