select * into tablename1
from (select mealrecords.emp_id,mealrecords.card_balance,mealrecords.sign_time
from (select emp_id,max(sign_time) as op from mealrecords group by emp_id) a inner join mealrecords
where a.emp_id=mealrecords.emp_id and a.op=mealrecords.sign_time )
提示:
第 4 行: ')' 附近有语法错误。
from (select mealrecords.emp_id,mealrecords.card_balance,mealrecords.sign_time
from (select emp_id,max(sign_time) as op from mealrecords group by emp_id) a inner join mealrecords
where a.emp_id=mealrecords.emp_id and a.op=mealrecords.sign_time )
提示:
第 4 行: ')' 附近有语法错误。
from (select mealrecords.emp_id,mealrecords.card_balance,mealrecords.sign_time
from (select emp_id,max(sign_time) as op from mealrecords group by emp_id) a inner join mealrecords
on a.emp_id=mealrecords.emp_id and a.op=mealrecords.sign_time) t
from (select mealrecords.emp_id,mealrecords.card_balance,mealrecords.sign_time
from (select emp_id,max(sign_time) as op from mealrecords group by emp_id) a inner join mealrecords
on a.emp_id=mealrecords.emp_id and a.op=mealrecords.sign_time) t
select mealrecords.emp_id,mealrecords.card_balance,mealrecords.sign_time
from (select emp_id,max(sign_time) as op from mealrecords group by emp_id) a inner join mealrecords
where a.emp_id=mealrecords.emp_id and a.op=mealrecords.sign_time