Results 1 to 2 of 2

Thread: count(*) problem

  1. #1
    Join Date
    Dec 2004
    Posts
    37

    count(*) problem

    Hi, I am new to the world of SQL and I have been trying to do a query and I was just wondering what I am doing wrong?
    Last edited by 182; 01-07-2005 at 02:56 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    select department, count(*) as Number# from
    (
    select a.departmentname as department,b.staffid from
    department a, staff b where
    a.dept_id=b.dept_id
    ) as mytable group by department

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •