'), 'DD') as date, lid, ROUND(SUM(spendCalc),2) as spend SELECT lid, bids.bid,bidRequestTime,price::float*COUNT(impression.bid)/1000::float/.80::float as s
这是我的Table1中的以下数据---------+-------------------+---------110909316904 2012-07-09 21:29:06因此,基本上,如果BIDSELECT bid, pid, rank(bid), time, UNIX_TIMESTAMP(time)
FROM