select top 100 lmdte, right(replicate('0',6)+ltrim(lmtme),6) from smtpdsum
where lmdte <> 0
select top 100 lmdte, right(replicate('0',6)+ltrim(lmtme),6) from smtpdsum
where lmdte <> 0
转载于:https://www.cnblogs.com/lengzhan/p/6256376.html