asp.net - SQL如何在一列中使用ORDER BY语句

Question

我需要通过此 SQl 语句进行排序以获得 <%# Eval("ICount") %> 的项目计数

问题是我不知道如何“ORDER BY”这个

SQL:

SELECT DATEPART(DAY,BLG_DATE) as DDay,
      datename(month,BLG_DATE) as DMonth,
       DATEPART(YEAR,BLG_DATE) as DYear,COUNT(BLG_DATE) as ICount
FROM [BLG] 
INNER JOIN [ACC] 
ON [BLG].ACC_ID=[ACC].ACC_ID 
WHERE [BLG].ACC_ID='1'and [BLG].BLG_DATE LIKE '%2013%' ORDER BY --????

ASP.NET:

<asp:Repeater ID="childRep" runat="server">
     <ItemTemplate>
          <li><a href="blog.aspx?month=<%# Eval("DMonth") %>"><em><%# Eval("DDay") %></em><%# Eval("DMonth") %><span><%# Eval("ICount") %></span></a></li>  
     </ItemTemplate>
 </asp:Repeater>

我需要 DMonth、DDay、DYear 和 ICount 列来填充 Repeater

注意:我只有表 BLG(BLG_ID,ACC_ID,BLG_DATE) 和 ACC(ACC_ID,ACC_USER,ACC_PASS)

Answer 1

这是你要找的吗？

SELECT DATEPART(DAY,BLG_DATE) as DDay,
      datename(month,BLG_DATE) as DMonth,
       DATEPART(YEAR,BLG_DATE) as DYear ,
       (SELECT COUNT(*) 
         FROM [BLG] 
          INNER JOIN [ACC]  ON [BLG].ACC_ID=[ACC].ACC_ID 
         WHERE [BLG].ACC_ID='1'and [BLG].BLG_DATE LIKE '%2013%') AS ICount
FROM [BLG] 
INNER JOIN [ACC] 
ON [BLG].ACC_ID=[ACC].ACC_ID 
WHERE [BLG].ACC_ID='1'and [BLG].BLG_DATE LIKE '%2013%'