Question

SQL语言两个表连接后怎么用group by。给个例子。。我的每次都有错

Answer 1

SELECT  *
FROM    ( SELECT    UniqID ,
                    CallTime
          FROM      dbo.APILog
          WHERE     UniqID = 100
          UNION
          SELECT    UniqID ,
                    CallTime
          FROM      dbo.APILog
          WHERE     UniqID = 200
        ) AS ta
GROUP BY ta.CallTime ,
        ta.UniqID;