I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answer Posted / radheshyam mali
Select sum(salary) from Employee group by deptno
Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
Where do we use pl sql?
State some properties of relational databases?
What do you mean by field in sql?
What is procedure and function in sql?
What is the largest value that can be stored in a byte data field?
What is on delete set null?
What is t sql used for?
how many groups of data types? : Sql dba
What is string data type in sql?
What is sqlerrm?
What is sql select statement?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How to select unique records from a table?
Why are indexes and views important to an organization?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?