在sql server中查找最大数据 [英] Find maximum data in sql server

问题描述

我有这种表，找到最大标记

i have this kind of table and find the maximum mark

学生

|id | name  | mark |
|1  | john  | 56   |
|2  | sara  | 81   |
|3  | mattew| 65   |

出来假设是这样

|id | name  | mark |
|2  | sara  | 81   |

但我得到这种输出

|id | name  | mark |
|1  | john  | 81   |

我在sql中写这个

SELECT id,name,MAX(mark)
FROM student;
WHERE name IN
(SELECT name
FROM student);

如何更正sql？

推荐答案

在SQL Server中，您可以使用

In SQL Server you can use

SELECT TOP 1 WITH TIES *
FROM student
WHERE mark IS NOT NULL
ORDER BY mark DESC

您也可以使用逻辑上等效的标准SQL

Though you could also use the logically equivalent standard SQL

SELECT *
FROM   student
WHERE  mark = (SELECT MAX(mark)
               FROM   student) 

这篇关于在sql server中查找最大数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！