我想这样做:
SELECT [Name] FROM MyTable WHERE IsAlive = 1 AND MIN(ID)
我想为MyTable中ID号最低的人获取[姓名],我想我快疯了。
MIN
聚合函数不会返回boolean
值。它将返回该结果集中该字段的MIN
。只需正确订购并抓住TOP 1
即可.
SELECT TOP 1 [Name] FROM MyTable WHERE IsAlive = 1 ORDER BY ID