在内部连接两次之后组成 - 通过上升进行排序

Question

练习sql并想要对我的查询的结果进行排序 - 原始查询运行良好，但是当通过其分组时无法运行。

使用SSMS '18-使用AdventureWorks数据库。

SELECT 
    pp.BusinessEntityID,
    pp.FirstName,
    pp.MiddleName,
    pp.LastName,
    ppw.PasswordHash,
    ppw.PasswordSalt,
    pph.PhoneNumber
FROM
    Person.Person AS pp
INNER JOIN
    Person.Password AS ppw ON pp.BusinessEntityID = ppw.BusinessEntityID
INNER JOIN
    Person.PersonPhone AS pph ON pp.BusinessEntityID = pph.BusinessEntityID
GROUP BY 
    pp.BusinessEntityID ASC, pp.FirstName, pp.MiddleName, pp.LastName, 
    ppw.PasswordHash, ppw.PasswordSalt, pph.PhoneNumber;

导致错误：

msg 156，15级，状态1，第21行
关键字" ASC"附近的错误语法。

，如果删除ASC关键字并通过BusinessEntityID降序将代码运行。我在这里错过了一些理论吗？

Answer 1

它将由

组成序列

SELECT 
 pp.BusinessEntityID,
 pp.FirstName,
 pp.MiddleName,
 pp.LastName,
 ppw.PasswordHash,
 ppw.PasswordSalt,
 pph.PhoneNumber
FROM
Person.Person as pp
    inner join Person.Password as ppw on  pp.BusinessEntityID=ppw.BusinessEntityID
    inner join Person.PersonPhone as pph on pp.BusinessEntityID=pph.BusinessEntityID
order by  pp.BusinessEntityID ASC, pp.FirstName, pp.MiddleName, pp.LastName, ppw.PasswordHash, ppw.PasswordSalt, pph.PhoneNumber;

但是，如果您想使用组，那将是

SELECT 
     pp.BusinessEntityID,
     pp.FirstName,
     pp.MiddleName,
     pp.LastName,
     ppw.PasswordHash,
     ppw.PasswordSalt,
     pph.PhoneNumber
    FROM
    Person.Person as pp
        inner join Person.Password as ppw on  pp.BusinessEntityID=ppw.BusinessEntityID
        inner join Person.PersonPhone as pph on pp.BusinessEntityID=pph.BusinessEntityID
    group  by  pp.BusinessEntityID , pp.FirstName, pp.MiddleName, pp.LastName, ppw.PasswordHash, ppw.PasswordSalt, pph.PhoneNumber;

，如果没有聚集，则更好的是，组合