select 语句怎么使用MAX（字段）？

[walkmanhan]

我想从一个dingdan表里，列出kehuID号最大的定单信息，用ADOQUERY写SQL时候不会写，我是这么写的select max(kehuID) FROM dingdan,但是在DBGRID里只能显示出来kehuID号的值，我想把NAME，TEL，都显示出来怎么写？
谢谢

[wuwoczj]

select max(kehuID),NAME,TEL FROM dingdan

[zleeway]

最好给字段起个别名
select max(kehuID) MaxID,NAME,TEL from dingdan

[qyyok]

up

[ihihonline]

我倒，前边的两位试了吗？
select kehuID,NAME,TEL FROM dingdan where kehuID = (Select max(kehuID) From dingdan)

----------------
沉沦中..........

[李_军]

select max(kehuID),NAME,TEL FROM dingdan

[gytyl]

select kehuID,NAME,TEL FROM dingdan where kehuID = (Select max(kehuID) From dingdan)

[walkmanhan]

谢谢： ihihonline(小小->），帅毕了，分都给你！！亲一下

[zhaofuquan]

select kehuID,NAME,TEL FROM dingdan
where kehuID = (Select max(kehuID) From dingdan)