SELECT ROW_NUMBER() OVER (ORDER BY aID DESC) AS 序号,aID,aName FROM [dbo].[Project] GROUP BY aID,aName;
主要是用 ROW_NUMBER() 加OVER(),这里还要注意分组,不像mysql那样只要group by一个字段,这里查的两个字段都要加上去!!!
SELECT ROW_NUMBER() OVER (ORDER BY aID DESC) AS 序号,aID,aName FROM [dbo].[Project] GROUP BY aID,aName;
主要是用 ROW_NUMBER() 加OVER(),这里还要注意分组,不像mysql那样只要group by一个字段,这里查的两个字段都要加上去!!!
近期评论