SQL Server：如果不满足条件，如何默认返回 1 行

使用SQL Server中的TOP和ORDER BY语句返回默认行数

sql
CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    EmployeeName VARCHAR(50),
    Salary DECIMAL(10, 2)
);
INSERT INTO Employees (EmployeeID, EmployeeName, Salary)
VALUES (1, 'John', 50000.00),
       (2, 'Alice', 60000.00),
       (3, 'Bob', 45000.00);

sql
SELECT TOP 1 EmployeeID, EmployeeName, Salary
FROM Employees
ORDER BY Salary DESC;
-- 如果没有符合条件的员工，则返回默认的一行数据
IF @@ROWCOUNT = 0
BEGIN
    SELECT 999 AS EmployeeID, 'No Employee Found' AS EmployeeName, 0.00 AS Salary;
END