- select id,haha+'('+CAST(id as VARCHAR(20))+')' as hhaaa from db --输出合并
- select DateDiff(d,时间,'2005-07-01') as w, 时间 from 招聘信息 where DateDiff(d,时间,'2005-07-01')<=DateDiff(d,'2005-06-01','2005-07-01') and DateDiff(d,时间,'2005-07-01')>=0 --查询2005-06-1至2005-07-01之间的数据
select id,haha+'('+CAST(id as VARCHAR(20))+')' as hhaaa from db
最新推荐文章于 2024-02-17 12:01:37 发布