SELECT username_from ufrom,COUNT(username_to) AS COUNT,(SELECT content FROM hit_exam_talk WHERE insert_time IN (SELECT MAX(insert_time) FROM hit_exam_talk WHERE username_from=ufrom) ) AS content FROM hit_exam_talk WHERE username_to=@username AND readFlag=0 GROUP BY username_from order by username_from
SELECT username_from,content,insert_time FROM hit_exam_talk WHERE username_from IN (@username_to,@username_from) AND username_to IN (@username_to,@username_from) order by insert_time