qq_41525524的博客

这里取的是日志表里面的数据logid是自动递增的唯一的 StudentId学生id取日志里面最新的全部记录（建议使用）select a.* from tb_l_Student ainner join (select max(logid) logid from tb_l_Student group by StudentId )b on b.logid = a.logid order ...

sql server 查询数据变成字符串;with datum as (select datumName from tb_b_datum where status = 1 )select DatumName= stuff((SELECT ',' + datumName FROM (select distinct datumName from datum) t1 for xml path('')),1,1,'')结果积分排行select DatumName , row_number()