Select Top 6 P.id,P.UId,P.Photo,P.PName,W.UId,W.CName from Products P inner join WUser W on W.UId=P.UId where P.id in
(Select top 6 max(id),UId from Products group by UId)"
----------
两者去掉一个
(Select top 6 max(id),UId from Products group by UId)"
----------
两者去掉一个
Select top 6 * from Products
????
P.id in
(Select top 6 max(id),UId from Products group by UId)
更加错误。!!
联表 WUser 查出该用户的姓名
该了一下:
Select P.id,P.UId,P.Photo,P.PName,W.UId,W.CName
from
(Select top 6 max(id) id,UId from Products group by UId) P
inner join WUser W
on W.UId=P.UId
Select Top 6 P.id,P.UId,P.Photo,P.PName,W.UId,W.CName from Products P inner join WUser W on W.UId=P.UId where P.id in
(Select top 6 max(id from Products group by UId)"
----------
两者去掉一个顺便问一个,为什么这一句可以通过?
Select top 6 max(id from Products group by UIdUId 没有包含在 Select 中啊??
我记得上次我试过不行的,提示说:没有包含在Select语句中,能告诉我为什么吗?
(2)是不是 Order by 后面的字段可以不包含在 Select 中的?