I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answer Posted / lova raju allumalla
instead of deptno the result will give u in department name
select sum(sal),dname from emp e,dept d where
e.deptno=d.deptno group by dname
/
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain constraints in sql?
How do I make sql search faster?
how to concatenate two character strings? : Sql dba
Why do we use procedures in sql?
How many types of primary keys are there?
What are the different types of sql commands?
Can one improve the performance of sql*loader? : aql loader
What is the least restrictive isolation level? : Transact sql
Difference between table function and pipelined function?
How do we accept inputs from user during runtime?
What is t-sql? : Transact sql
What is cross join sql?
Explain table and field in sql?
What are schema-level triggers?
Is sql port 1433 encrypted?