{"id":288,"title":"sql\u5206\u7ec4","good":0,"bad":0,"hit":2210,"created_at":"2018-06-14 22:16:31","content":"<p>\u5206\u7ec4<\/p><p>\u627e\u51faid&gt;10\u7684\uff0c\u6309\u73ed\u5206\u7ec4\uff0c\u4e14\u5206\u7ec4\u7ec4\u91cc\u8bb0\u5f55\u5927\u4e8e3\u7684\uff1b<\/p><p>select id,class from users where id&gt;10 group by class having count(id)&gt;3;<\/p><p>\u5148\u6309\u5e74\u9f84\u4ece\u5c0f\u5230\u5927\u6392\uff0c\u5982\u679c\u5e74\u9f84\u76f8\u540c\uff0c\u5219\u626bid\u4ece\u5927\u5230\u5c0f\u6392<\/p><p>select * from users order by age,id desc;<\/p><p><br\/><\/p>"}