Thursday, 5 September 2013

sql query to display deptname and other stuff but giving right paranthesis error

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