一条简单的SQL语句问题，请高手指点

[zhangwei110]

我要求出列DocNum = '0000012345' 并且LineNum列最大的那条数据。
我像以下这样写，命令是完成了，但是执行的时候报错了。请高手指点该怎么写
网上查了是聚合函数的原因，听别人说要用 having 但是不知道怎么。
Select DocNum,max(LineNum),ItemCode,Dscription,Quantity,U_zld,VatGroup,Price,U_LotNo from OrderItem where (1 = 1) and (DocNum = '0000012345')

[BearRui]

try

select * from OrderItem
where DocNum = '0000012345' AND LineNum = (select max(LineNum) from OrderItem where DocNum = '0000012345' group by DocNum)

[paoluo]

可以使用TOP， 不需使用子查詢。

Select TOP 1 DocNum,LineNum,ItemCode,Dscription,Quantity,U_zld,VatGroup,Price,U_LotNo from OrderItem where (1 = 1) and (DocNum = '0000012345') Order By LineNum Desc

[paoluo]

或者使用關聯


Select A.DocNum,A.LineNum,A.ItemCode,A.Dscription,A.Quantity,A.U_zld,A.VatGroup,A.Price,A.U_LotNo
from OrderItem A Inner Join
(Select DocNum, Max(LineNum) As LineNum from OrderItem Group By DocNum) B
On A.DocNum = B.DocNum And A.LineNum = B.LineNum
where (1 = 1) and (A.DocNum = '0000012345')

[sansuihub]

select top 1 * from OrderItem where DocNum = '0000012345' order by LineNum desc

[caowenkai]

1楼的朋友正解，感觉用top做的话不是很。