摘要:
SELECT slnname, (SELECT REVERSE(LEFT (REVERSE(projectid),LOCATE('G', REVERSE(projectid)) - 1))) AS numb FROM pmaunew ORDER BY numb 其他分割:https://www.cn 阅读全文
摘要:
--查询当天: select * from info where DateDiff(dd,datetime,getdate())=0 --查询24小时内的: select * from info where DateDiff(hh,datetime,getDate())<=24 --查询本周记录se 阅读全文