Mysql 如何查询最小值？

[spring0906]

表 PTest 结构结构如下

PCode PCount
7 3
8 2
9 3
10 4
11 2

查询结果是
PCode PCount
8 2

规则是：先考虑PCount最小，再考虑PCode最小
（注：PCode和PCount都是无序的，Pcode 唯一）

[dalmeeme]

SELECT * from PTest WHERE PCode=(SELECT min(PCode) FROM PTest WHERE PCount=(SELECT min(PCount) from PTest))

经验证可以。

[dalmeeme]

哦，好像不对。

[dalmeeme]

貌似可以嘛～～我修改了下数据，试了一下，暂时没发现问题。

[flyhorse999]

select pcode,pcount from ptest where pcount=(select min(pcount) from ptest) order by pcode limit 1

估计应该可以，没测试过。

[瑞卡哥哥]

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)
  

[e_board]

select *
from ptest
order by pcount,pcode limit 1