SQL求相互关注的人数和关注了4的总关注数

最新推荐文章于 2024-01-31 13:47:35 发布

beat_it

最新推荐文章于 2024-01-31 13:47:35 发布

阅读量679

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/beat_it_/article/details/73655873

版权

sql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

求互相关注的人数？

select count(1) from tst t1
inner join tst t2
on t1.uid = t2.uuid and t1.uuid = t2.uid;

求关注了4的总关注数？

select count(1) from tst t1
inner join (select uid from tst where uuid = '4') t2
on t1.uid = t2.uid;

-- ----------------------------

-- Table structure for `tst`
-- ----------------------------
DROP TABLE IF EXISTS `tst`;
CREATE TABLE `tst` (
`uid` int(10) NOT NULL,
`uuid` int(10) NOT NULL,
`desc` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tst
-- ----------------------------
INSERT INTO `tst` VALUES ('1', '2', null);
INSERT INTO `tst` VALUES ('1', '3', null);
INSERT INTO `tst` VALUES ('1', '4', null);
INSERT INTO `tst` VALUES ('2', '5', null);
INSERT INTO `tst` VALUES ('2', '1', null);
INSERT INTO `tst` VALUES ('3', '4', null);
INSERT INTO `tst` VALUES ('3', '1', null);
INSERT INTO `tst` VALUES ('5', '4', null);
INSERT INTO `tst` VALUES ('5', '6', null);
INSERT INTO `tst` VALUES ('5', '1', null);