2019-03-16
阅读量:
575
SQL语句优化
问题描述:
SELECT
(SELECT
MAX(`word_id`)
FROM
`tbl_user_words`
WHERE `member_id` = 1) AS max_id,
(SELECT
COUNT(`word_id`)
FROM
`tbl_user_words`
WHERE `right_count` < 5
AND `member_id` = 1) AS num ;
以上语句如何优化呢?
解决方法:
SELECT MAX(`word_id`) AS max_id, SUM(`right_count` < 5) as num
FROM `tbl_user_words`
WHERE `member_id` = 1;






评论(0)


暂无数据
推荐帖子
0条评论
0条评论
1条评论