sql group by

表 table_a | id_a | data_a | name_a | type_a |

表 table_b | id_b | data_b | name_b | type_b |

表 table_c | id_c | data_c | name_c | type_c |

select id_a,data_a,b.name_b,c.name_c,c.type_c from table_a a
left join (select id_b,data_b,name_b from table_b) b on a.id_a =b.id_b
left join (select id_c,data_c,type_c from table_c) c on a.id_a=c.id_c
group by ??

group by 后面怎么写？

是不是 slecte 后面对应的字段，都要在 group by 后面有相应的 分组？

sql查询 group by SQL group by 问题 SQL GROUP BY 问题 SQL中的GROUP BY sql中关于group by sql Group by 的使用 sql group by 报错 sql group by 的问题 SQL语句中GROUP BY使用 SQL Server2000中Group By的用法？