select a.guigename,a.thisdayguigeprice,a.createdate
from dailystandardguigeprice as a
inner join (select guigename,max(createdate) as mcreatedate from dailystandardguigeprice group by guigename) as b
on a.guigename=b.guigename and a.createdate=b.mcreatedate