SqlServer教程

SQLServer MAX()

SQLServer MAX()函数用于返回表达式的最大值。
语法:
SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions];
示例:
选择"雇员"表并获取该表的最高工资。
SELECT MAX(salary) AS "Highest Salary"
FROM Employees; 
输出:
SQL服务器最大功能1
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4