表 PTest 结构结构如下PCode PCount
7 3
8 2
9 3
10 4
11 2查询结果是
PCode PCount
8 2规则是:先考虑PCount最小,再考虑PCode最小
(注:PCode和PCount都是无序的,Pcode 唯一)
7 3
8 2
9 3
10 4
11 2查询结果是
PCode PCount
8 2规则是:先考虑PCount最小,再考虑PCode最小
(注:PCode和PCount都是无序的,Pcode 唯一)
SELECT * from PTest WHERE PCode=(SELECT min(PCode) FROM PTest WHERE PCount=(SELECT min(PCount) from PTest)) and PCount=(select min(PCount) from PTest)
SELECT * from PTest
WHERE
PCode=
(
SELECT min(PCode) FROM PTest
WHERE PCount=(SELECT min(PCount) from PTest)
)
and
PCount=(select min(PCount) from PTest)
from ptest
order by pcount,pcode limit 1