SQL-选择具有最大值的所有行 [英] SQL - selecting all rows with maximum value

问题描述

我有这个SQL查询:

SELECT id, COUNT(*) AS price
FROM (SELECT * FROM rt WHERE somecondition) AS st
      JOIN tt
      ON st.id = tt.id
GROUP BY id;

现在，我要选择具有表最高价格的所有行.我已经尝试过了，不幸的是根本没有返回任何行:

Now, I want to select all rows which have the maximum price of the table. I have tried this, which unfortunately returns no row at all:

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);

我有点迷茫，有人有指针吗?

I'm somewhat lost, does anybody have any pointers?

推荐答案

在我看来，这很简单:

select * from <table> 
where <column name> in(
   SELECT MAX(column name) FROM table
)

这篇关于SQL-选择具有最大值的所有行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！