SQL语句问题

以前写SQL时一直很生硬的写着一条一条。效率很低。因为它不能有效的结合在一起。今天尝试了一下。果然可以。也让我欣喜万分，特意拿来与大家共同分享。但是有些认为我是菜鸟的话，也不要笑话我哦。谢谢。

 

select t1.IDas ID,max(t2.Col1) as Col1,Max(t2.Col2) as Col2,sum(Col3) AS Col3,sum(Col4) AS Col4,Convert(numeric(5,2),avg(Col5)) AS Col5,  sum(Col6) AS Col6,sum(Col7) AS Col7,sum(Col8) AS Col8,(select top 1 Col9 from BasIncrDeclaMonthVeri  where BasIncrDeclaMonthVeri.ItemID=t1.ItemID order by EnYear desc,EnMonth desc) AS Col9 ,
(select top 1 Col10 from BasIncrDeclaMonthVeri  where BasIncrDeclaMonthVeri.ItemID=t1.ItemID order by EnYear desc,EnMonth desc) AS Col10 
 from BasIncrDeclaMonthVeri t1 left join BasEnteBasicInfo t2 on t1.ItemID=t2.ItemID
where t1.Status='1'
group by t1.ID

 

在select sum(),sum(),from table1 里可以加一个select语句，这样更好的把结果放到datagrid 或gridview里面。