在MySQL中查询满足两个字段最小值的记要

在MySQL中查询满足两个字段最小值的记录

在做项目的过程中，我遇到了一个查询数据库的问题。。。

就是项目需要查询一个表中的一条记录

而这条记录需要同时满足的条件就是：价格最低、以及时间最早

我写的SQL语句如下：

–竞拍信息表

CREATE TABLE customerauction(

       id int primary key auto_increment,

       phone varchar(20) not null,      

       auctionprice double(4,2) not null,      

       isbn varchar(20) not null,      

       userauctiondate  datetime not null

);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘1′,2.0,’sdsdsds’,’1908-04-05 09:29:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘2′,2.0,’sdsdsds’,’1908-04-05 09:29:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘8′,1.0,’sdsdsds’,’1908-04-05 09:29:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘3′,1.0,’sdsdsds’,’1908-04-05 09:39:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘4′,1.0,’sdsdsds’,’1908-04-05 09:49:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘5′,2.0,’sdsdsds’,’1908-04-05 09:59:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘6′,2.0,’sdsdsds’,’1908-04-05 09:19:09′);

insert into customerauction (phone,auctionprice,isbn,userauctiondate) values(‘7′,2.0,’sdsdsds’,’1908-04-05 09:09:09′);

select * from customerauction;

查询语句：

select * FROM (select * from customerauction order by userauctiondate ) as aaa group by auctionprice limit 0,1;