2022-12-15:尋找用戶推薦人。寫一個查詢語句,返回一個客戶列表,列表中客戶的推薦人的編號都 不是 2。
對于示例數(shù)據(jù),結(jié)果為:
+------+
| name |
+------+
| Will |
| Jane |
| Bill |
| Zack |
+------+
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`referee_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `customer` VALUES (1, Will, null);
INSERT INTO `customer` VALUES (2, Jane, null);
INSERT INTO `customer` VALUES (3, Alex, 2);
INSERT INTO `customer` VALUES (4, Bill, null);
INSERT INTO `customer` VALUES (5, Zack, 1);
INSERT INTO `customer` VALUES (6, Mark, 2);
#福大大架構(gòu)師每日一題#
對于示例數(shù)據(jù),結(jié)果為:
+------+
| name |
+------+
| Will |
| Jane |
| Bill |
| Zack |
+------+
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`referee_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `customer` VALUES (1, Will, null);
INSERT INTO `customer` VALUES (2, Jane, null);
INSERT INTO `customer` VALUES (3, Alex, 2);
INSERT INTO `customer` VALUES (4, Bill, null);
INSERT INTO `customer` VALUES (5, Zack, 1);
INSERT INTO `customer` VALUES (6, Mark, 2);
#福大大架構(gòu)師每日一題#
2022-12-15
在牛客打卡833天,今天也很努力鴨!
全部評論
相關(guān)推薦
點贊 評論 收藏
分享
05-15 13:45
青島大學(xué) C++ 點贊 評論 收藏
分享