我有一个用户表:
|username|UserType|
|John |A |
|Mary |A |
|Anna |B |
和UserPoints
|UserType|MinPoints|Level |
|A |100 |Bronze |
|A |200 |Silver |
|A |300 |Gold |
|B |500 |Bronze |
和用户地址
|UserType|Address
|A |Address1
|B |Address2
我正在寻找查询以获取MinPoints列的最大值。
我想要不使用Group by子句的结果。 我尝试了以下
Select UserType,UA.Address,(Select max(MinPoints) from Users T1 WHERE T1.Usertype=U.Usertype)MinPoints from Users U
Left Join UserAddress UA on UA.UserType=U.UserType
Select UserType,MinPoints
from Users U
Left Join UserAddress UA on UA.UserType=U.UserType
Left Join (Select UserType,max(MinPoints) from Users T1 Group by UserType) x ON X.Usertype=U.Usertype
对于以上查询,我得到了相同的结果。 但是我想要的是查询更好地了解性能。
请建议