热线电话:13121318867

登录
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.0000
4
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子