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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-04-22 : 05:12:53
|
| What is the difference between distinct and group by please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-22 : 05:27:18
|
| Cant spot any problems with your where query. What discrepancy are you experiuencing? Can you elaborate with some sample data? |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-04-22 : 05:29:03
|
| sorry, initially I sent the wrong syntax. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-22 : 05:45:39
|
| distinct takes only the unique combination of the resultset fields while group by groups the resultset based on specified fields and returns you the grouped or summarised data. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-25 : 04:29:20
|
where is the original post? --------------------keeping it simple... |
|
|
|
|
|
|
distinct