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 |
|
mitasid
Yak Posting Veteran
51 Posts |
 Posted - 2006-06-06 : 18:56:00
|
| Can we have a group by without an aggregate??for ex if i have a table company id year units_jan units_feb...units_decqqq 2 2000 66 55........667 4 2000 33 22 21i want to group it by id but i dont want any aggregate field..how shall i do this?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-06 : 18:57:53
|
| GROUP BY requires an aggregate function. Let's continue this discussion in the other thread that you have. We are responding to you in a very timely fashion, so there is no need to start a new one.Tara Kizeraka tduggan |
 |
|
|
|
|
|
group by