I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answer Posted / vikneswaran
SELECT deptno,SUM(sal) FROM emp
GROUP BY deptno
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What are the types of join and explain each?
what are different types of keys in sql?
What is the difference between a primary key and a unique key?
how would you get the current date in mysql? : Sql dba
what are rollup and cube in t-sql? : Transact sql
Do foreign keys improve performance?
Is sql workbench free?
What is nosql example?
Which data dictionary views have the information on the triggers that are available in the database?
What is the difference between having clause and where clause?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is trigger and how to use it in sql?
What are secondary keys?
Why are aggregate functions called so?