OraFAQ Forum: SQL & PL/SQL » Emp,Dept--Doubt

Home » SQL & PL/SQL » SQL & PL/SQL » Emp,Dept--Doubt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Emp,Dept--Doubt [message #23325]

Mon, 02 December 2002 02:38

Suresh
Messages: 189
Registered: December 1998

Senior Member

Hi,

As all of us aware of EMP,DEPT Table. In this i want to write a query like below.

Deptno Dname No.of Employees
==================================
10 Sales 23
20 Marketing 34
30 Accounts 87
40 Computer 23

Can Anyone can help this?

Regards
Suresh

Report message to a moderator

Re: Emp,Dept--Doubt [message #23326 is a reply to message #23325]

Mon, 02 December 2002 03:17

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> ed
Wrote file afiedt.buf

  1  select dept.deptno,dept.dname,count(empno)
  2  from emp,dept
  3  where dept.deptno=emp.deptno(+)
  4* group by dept.deptno,dept.dname
SQL> /

    DEPTNO DNAME          COUNT(EMPNO)
---------- -------------- ------------
        10 ACCOUNTING                3
        20 RESEARCH                  5
        30 SALES                     6
        40 OPERATIONS                0

SQL>

Report message to a moderator

Previous Topic:	function values and fun query
Next Topic:	sql to copy records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 05:27:34 CDT 2024