贴两个sql

来源:互联网 发布:js 如何拖拽 编辑:程序博客网 时间:2024/06/14 14:51

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








原创粉丝点击