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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-02 : 11:57:37
|
mala writes "Hi,
I want result to be grouped on i_partno and i_zone not on all.
eg.
i_partno i_zone i_batch i_location
100001 z001 abc001 a_loc
100001 z001 abd001 b_loc
100002 z001 abc001 a_loc
100002 z003 abc001 b_loc
Now if I write select statement to select all the columns, but has to be grouped only on i_partno and i_zone
mala" |
|
|
|
|
|
Group by clause