分组后取时间最新的数据
SELECT max(Id)/*注意Id必须使用聚合函数Max*/ , Pid, MAX(Time) as MaxTime FROM Test GROUP BY pid
2020
kim excel VLOOKUP 入门
如上，查找橙子的金额。=VLOOKUP(D2,A2:B5,2,FALSE)
sql server 视图刷新 视图重构
sp_refreshview VIEW_viewName
sql server删除重复记录只保留一条
delete from sys_project from sys_project as aa left join ( select min(id) as id from…