在SQL Server中发现Gettin错误，同时找出表中的最大年龄(Gettin error in SQL Server while finding out max age in a table)

在SQL Server中发现Gettin错误，同时找出表中的最大年龄(Gettin error in SQL Server while finding out max age in a table)

我们可以简单地通过使用来尝试获得最大年龄

SELECT TOP 1 age FROM Head1 ORDER BY Age DESC

但我已经尝试在SQL Server中使用while循环

码

declare @a int, @m int, @maxo int; set @maxo = 0; while(@a<10) begin select name, @m = age from head1 where ID = @a; if @m>@maxo @maxo = @m; set @a=@a+1; end print @maxo

错误

消息141，第15级，状态1，第5行 一个给变量赋值的SELECT语句不能与数据检索操作结合使用。

Msg 102，Level 15，State 1，Line 7 “@maxo”附近的语法错误。

我有点卡在这里。 请帮帮人......

We can try to get max age simply by using

SELECT TOP 1 age FROM Head1 ORDER BY Age DESC

But I've tried using while loop in SQL Server

code

declare @a int, @m int, @maxo int; set @maxo = 0; while(@a<10) begin select name, @m = age from head1 where ID = @a; if @m>@maxo @maxo = @m; set @a=@a+1; end print @maxo

error

Msg 141, Level 15, State 1, Line 5 A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Msg 102, Level 15, State 1, Line 7 Incorrect syntax near '@maxo'.

I am sort of stuck here. Please help guys.....

最满意答案

declare @a int, @m int, @maxo int declare @name NVARCHAR(100) set @maxo = 0; while(@a<10) begin select @name = name, @m = age from head1 where ID = @a; if @m>@maxo SET @maxo = @m; set @a=@a+1; END PRINT @name + ',' + CAST(@maxo AS NVARCHAR(50))

替代方法是

SELECT Name, Age FROM Header1 WHERE Age = (SELECT MAX(Age) FROM Header1) declare @a int, @m int, @maxo int declare @name NVARCHAR(100) set @maxo = 0; while(@a<10) begin select @name = name, @m = age from head1 where ID = @a; if @m>@maxo SET @maxo = @m; set @a=@a+1; END PRINT @name + ',' + CAST(@maxo AS NVARCHAR(50))

ALTERNATE WAY IS

SELECT Name, Age FROM Header1 WHERE Age = (SELECT MAX(Age) FROM Header1)