SQL求互关的对数

 

-- 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);

-- 法一：
select 
       if(uid<uuid