php - 错误 - 以前发现了一个别名。(靠近位置 61 的“排名”)
问题描述
代码-
CREATE TABLE IF NOT EXISTS `scores` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL DEFAULT 'ram',
`score` int(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `scores`
--
INSERT INTO `scores` (`id`, `name`, `score`) VALUES
(1, 'ram', 200),
(2, 'ram', 200),
(3, 'ram', 200),
(4, 'ram', 80),
(5, 'ram', 55),
(6, 'ram', 40),
(7, 'ram', 30),
(8, 'ramu', 80),
(9, 'ram', 70),
(10, 'ram', 45),
(11, 'ram', 40),
(12, 'ram', 30),
(13, 'ram', 65),
(14, 'ram', 70),
(15, 'ram', 45),
(16, 'ram', 55),
(17, 'ram', 45),
(18, 'ram', 83),
(19, 'ram', 85),
(20, 'ram', 60),
(21, 'ram', 50),
(22, 'ram', 40),
(23, 'ram', 75),
(24, 'ram', 80),
(25, 'ram', 55),
(26, 'ram', 40),
(27, 'ram', 30),
(28, 'ram', 80),
(29, 'ram', 70),
(30, 'ram', 45),
(31, 'ram', 40),
(32, 'ram', 30),
(33, 'ram', 65),
(34, 'ram', 70),
(35, 'ram', 45),
(36, 'ram', 55),
(37, 'ram', 45),
(38, 'ram', 83),
(39, 'ram', 85),
(40, 'ram', 60),
(41, 'ram', 50),
(42, 'ram', 40),
(43, 'ram', 75),
(44, 'ram', 80),
(45, 'ram', 55),
(46, 'ram', 40),
(47, 'ram', 30),
(48, 'ram', 80),
(49, 'ram', 70),
(50, 'ram', 45),
(51, 'ram', 40),
(52, 'ram', 30),
(53, 'ram', 65),
(54, 'ram', 70),
(55, 'ram', 45),
(56, 'ram', 55),
(57, 'ram', 45),
(58, 'ram', 83),
(59, 'ram', 85),
(60, 'ram', 60),
(61, 'ram', 50),
(62, 'ram', 40),
(63, 'ram', 75),
(64, 'ram', 80),
(65, 'ram', 55),
(66, 'ram', 40),
(67, 'ram', 30),
(68, 'ram', 80),
(69, 'ram', 70),
(70, 'ram', 45),
(71, 'ram', 40),
(72, 'ram', 30),
(73, 'ram', 65),
(74, 'ram', 70),
(75, 'ram', 45),
(76, 'ram', 55),
(77, 'ram', 45),
(78, 'ram', 83),
(79, 'ram', 85),
(80, 'ram', 60),
(81, 'ram', 50),
(82, 'ram', 40),
(83, 'ram', 75),
(84, 'ram', 80),
(85, 'ram', 55),
(86, 'ram', 40),
(87, 'ram', 30),
(88, 'ram', 80),
(89, 'ram', 70),
(90, 'ram', 45),
(91, 'ram', 40),
(92, 'ram', 30),
(93, 'ram', 65),
(94, 'ram', 70),
(95, 'ram', 45),
(96, 'ram', 55),
(97, 'ram', 45),
(98, 'ram', 83),
(99, 'ram', 85),
(100, 'ram', 60),
(101, 'ram', 50),
(102, 'ram', 40),
(103, 'ram', 75),
(104, 'ram', 80),
(105, 'ram', 55),
(106, 'ram', 40),
(107, 'ram', 30),
(108, 'ram', 80),
(109, 'ram', 70),
(110, 'ram', 45),
(111, 'ram', 40),
(112, 'ram', 30),
(113, 'ram', 65),
(114, 'ram', 70),
(115, 'ram', 45),
(116, 'ram', 55),
(117, 'ram', 45),
(118, 'ram', 83),
(119, 'ram', 85),
(120, 'ram', 60),
(121, 'ram', 50),
(122, 'ram', 40),
(123, 'ram', 75),
(124, 'ram', 80),
(125, 'ram', 55),
(126, 'ram', 40),
(127, 'ram', 30),
(128, 'ram', 80),
(129, 'ram', 70),
(130, 'ram', 45),
(131, 'ram', 40),
(132, 'ram', 30),
(133, 'ram', 65),
(134, 'ram', 70),
(135, 'ram', 45),
(136, 'ram', 55),
(137, 'ram', 45),
(138, 'ram', 83),
(139, 'ram', 85),
(140, 'ram', 60),
(141, 'ram', 50),
(142, 'ram', 40),
(143, 'ram', 75),
(144, 'ram', 80),
(145, 'ram', 55),
(146, 'ram', 40),
(147, 'ram', 30),
(148, 'ram', 80),
(149, 'ram', 70),
(150, 'ram', 45),
(151, 'ram', 40),
(152, 'ram', 30),
(153, 'ram', 65),
(154, 'ram', 70),
(155, 'ram', 45),
(156, 'ram', 55),
(157, 'ram', 45),
(158, 'ram', 83),
(159, 'ram', 85),
(160, 'ram', 60);
select *, RANK() OVER (ORDER BY score DESC) AS `ranking` from scores;
笔记-
- 在https://paiza.io/en/projects/new?language=mysql中完美运行
- 无法在 phpmyadmin 上运行
向你们请求助手。谢谢
解决方案
推荐阅读
- spring - EventListener 和可重试
- ruby-on-rails - 将 curl 请求转换为 Rails Net::HTTP
- android - 如何仅显示当前月份并预览在 datePickerDialog 中可选择的月份日期?
- mysql - SQL获取一列值的计数并按另一列分组
- python-3.x - 音频到文本的速度很慢,并且单词正在丢失
- python - 打印出一个函数和一个字符串不起作用!Python
- java - 如何配置 Spring/Springboot 访问主页?
- indexing - powerbi 起始索引为“0”还是“1”?
- ios - 如何在 ios 中从图像选择器中选择时以自由方式裁剪图像(根据用户需要)
- runtime-error - Pythonwin.exe 不指出运行时错误的代码行