查询房间表中每个房型的最高价格和对应的房间号！这个房型的对应价格好说，但是房间号做不出来

Question

#我的初步错误答案是 select room _type,max(price),room _id from Room group by room_type

Answer 1

你是不是没学过TSQL，group by后面要跟上非聚合函数的所有列：

SELECT room _type, MAX(price) AS high, room_id
FROM Room
GROUP BY room _type,room _id