最近 30天 加入的公司
SELECT ID,cName title,[User_Name] fName,User_AddTime AddTime,'' fPath FROM vUser WHERE DATEDIFF(DAY,User_AddTime,GETDATE())<30 AND User_Type>0 AND User_State=1 ORDER BY User_AddTime DESC