-
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.
-
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
-
Forum Rules
|
|