比如
Col1,Col2,Col3,Col4.Col5,.........项目很多按照Col1,Col2,Col3 分组后,做多只要10条,该怎么写好?
Select *
From Tb
Group By Col1,Col2,Col3
Col1,Col2,Col3,Col4.Col5,.........项目很多按照Col1,Col2,Col3 分组后,做多只要10条,该怎么写好?
Select *
From Tb
Group By Col1,Col2,Col3
From Tb
Group By Col1,Col2,Col3
select * from tb a where id in(select id from tb where a.col1=col1 and a.col2=col2 and a.col3=col3 group by col1,col2,col3)
= CSDN助手 全面支持CSDN论坛 =
= 监视、收藏、历史、签名走马灯 =
==================================