Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bauerb
Starting Member
1 Post |
 Posted - 2008-10-05 : 19:38:35
|
| having trouble with some very rudimentary code. too many hours at it.what is the problem with this code:SELECT department_id FROM employees GROUP BY department_id HAVING count(employee_id) < 6is this code even valid? what should the expected result be. sorry for the dumb first post, I've having a brain fa**. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 00:28:55
|
| the sql server code is valid. What you're doing here is trying to get ids of departments having less than 6 employees. |
 |
|
|
|
|
|
need basic SQL help