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 |
|
ravaluri
Starting Member
1 Post |
 Posted - 2009-07-14 : 03:28:28
|
| hi am very new to this forum, and am new to sql server also regarding my practicing am not getting where to use and where to not use the "group by " clause, plz refer me some thing regading to this issueravaluri |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-14 : 03:38:43
|
GROUP BY goes together with aggregate function like SUM(), MIN(), MAX() etc.There isn't any rules to say "where to use" or "where not to use". It is very much depends on the situation
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-14 : 03:44:40
|
| Also refer..http://www.sqlteam.com/article/how-to-use-group-by-in-sql-server-------------------------R.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-14 : 13:46:49
|
| as name suggest GROUP BY is used whenever you require to display aggregated form of output from data i.e whenever you need to display some grouped info based on one or more fields like count,sum,average,... |
|
|
|
|
|
|
hi