我有这个 SQL 查询：
SELECT id, COUNT(*) AS price
FROM (SELECT * FROM rt WHERE somecondition) AS st
JOIN tt
ON st.id = tt.id
GROUP BY id;
现在，我想选择表中具有最高价格的所有行。我已经尝试过这个，不幸的是它根本没有返回任何行：
SELECT id, COUNT(*) AS price
FROM (SELECT * FROM rt WHERE somecondition) AS st
JOIN tt
ON st.id = tt.id
GROUP BY id
HAVING price = MAX(price);
我有点迷失了，有人指点一下吗？
这对我来说看起来相当简单：
select * from <table>
where <column name> in(
SELECT MAX(column name) FROM table
)
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
