SQL
文章平均质量分 76
qq_32722591
这个作者很懒,什么都没留下…
展开
-
SQL嵌套查询
SELECT `a`.`id`, GROUP_CONCAT(`p`.`title`) FROM `table1` `a` LEFT JOIN `table2` `p` ON `p`.`code`=`a`.`code` GROUP BY `a`.`id`原创 2017-01-18 10:15:10 · 148 阅读 · 0 评论 -
SQL查询重复值
查询数据库字段的重复出现 select * from `A` where `id` in (select `id` from `A` WHERE `s_id` = 5 group by `id` having count(1) >= 2)翻译 2017-01-20 14:27:51 · 175 阅读 · 0 评论 -
SQ语句查询统计嵌套查询查询速度不怎么理想
SELECT (tangniaobing) tangniaobing,(gaoxueya) gaoxueya,(yunfu) yunfu, (chanfu) chanfu, (canjiren) canjiren, (jiehebing) jiehebing, (jingshenbing) jingshenbing, (jihua) jihua,(wubao) wubao, (shin...原创 2018-06-13 14:55:32 · 278 阅读 · 0 评论