mysql选择最大值(value)

Question

一张 table

MODEL(IDMODEL inc., NAME text)

一张 table

DOC(IDDOC inc., NAME text, RELEASE numeric, IDMODEL numeric)

DOC 中的记录验证 DOC.IDMODEL == MODEL.IDMODEL。

我想从 DOC 中选择具有 RELEASE 最大值的所有记录。

来自模型的数据:

"1" "specification"
"2" "cahier de test"

来自 DOC 的数据:

iddoc   name        release idmodel
"1" "doc 1.1"   "1" "1"
"2" "doc 1.2"   "2" "1"
"3" "doc 2.1"   "1" "2"
"4" "doc 2.2"   "2" "2"
"5" "doc 2.3"   "3" "2"  > required
"6" "doc 1.3"   "3" "1"
"7" "doc 1.4"   "4" "1"  > required
"8" "doc 2 bis.1"   "1" "2"
"9" "doc 2 bis.2"   "2" "2"
"10" "doc 2 bis.3"  "3" "2"  > required

你能帮我执行 SELECT 命令吗？

致以诚挚的问候。

Answer 1

使用子选择尝试这种方式:

SELECT * 
FROM DOC 
WHERE release=(
    SELECT max(release) FROM DOC
    )

或者

 SELECT * from DOC ORDER BY release DESC LIMIT 1;