CREATE TABLE `fans` (
`id` int(20) NOT NULL,
`team` varchar(10) DEFAULT NULL,
`nationality` varchar(20) DEFAULT NULL,
`fanCount` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
)
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('1','Barcelona','Germany','12000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('2','Barcelona','Spain','18000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('3','Barcelona','China','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('4','Barcelona','USA','15000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('5','Barcelona','Italy','11000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('6','Real Madri','France','19000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('7','Real Madri','Germany','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('8','Real Madri','USA','17000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('9','Real Madri','Korea','16000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('10','Real Madri','UK','12000');
uj5u.com熱心網友回復：
慢慢來，你先把需求說清楚，按team分組查詢每組粉絲數量排前三的國家和粉絲數量你是這個意思嗎?
uj5u.com熱心網友回復：
對的，就是這個意思轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/85470.html
標籤：MySQL
上一篇：求助資料庫多表查詢問題