sql查询增加常量列

增加data_type字段，展示为max

SELECT
tesxt,'max' as data_type,
max(name) name,max(age) age ,max(tex)
from student s 
group by tesxt