Mysql查询当天第一天记录

select bm.MarketCode from bills_market bm where bm.create_time >= date(now()) and bm.create_time < DATE_ADD(date(now()),INTERVAL 1 DAY) ORDER BY bm.MarketCode DESC LIMIT 1

没有Top 1