【问题】 获取用户最近一次记录的
如下表:
select min(create_date) create_date From (select project_id,create_date from t where project_id is not null and record_type= 1 and create_date is not null and flag_delete = 0 order by create_date asc ) min group by project_id
注:如果想获取最后一次可以用max 函数处理,如下:
select max(create_date) create_date From (select project_id,create_date from t where project_id is not null and record_type= 1 and create_date is not null and flag_delete = 0 order by create_date desc) min group by project_id