我想应该先把max(aaa)求出来,再作为查询的where条件才行吧??
----------------------------------------------
Function IThink(Boy,Girl : TPerson) : String; begin if Boy.钱 < 10W then Girl.Say(''滚!'') else begin if Girl.Anser = ''我愿意'' then Result := ''结婚'' else Result := IntToStr(88); end; 风过不折→百炼成尧 QQ: 7315910
这里应该用到 select 语句的嵌套, SELECT b.AAA,b.BBB,b.CCC FORM (select Max(AAA) AS MaxAAA from mytable) AS a (select AAA,BBB,CCC from mytable) AS b WHERE B.AAA = a.MaxAAA
----------------------------------------------
用7楼的不如用下面的,不一样吗? select max(aaa) as aaa ,bbb,ccc from mytable; 或者真的要用嵌套也可以如下: select aaa,bbb,ccc from mytable where aaa in(select max(aaa) as aaa frim mytable);
----------------------------------------------
<<努力自信爱心>>菜鸟中的菜鸟
以sql server 中的orders 表为例查询最大的orderid select max(orderid) as maxid from orders 可以去试一下1楼的兄弟说得对 返回可以用个苯办法, sql.add('select max(orderid) as maxid from orders'); datasource1.dataset:=adoquery1; dbedit1.datasource:=datasource1; dbedit1.datafield:=orderid; adoquery1.active:=true; 其它语句自己去添,应该没有问题,我没有试,自己去看看吧!
----------------------------------------------
X
sql server : use pubs select stor_id,qty from sales where qty=(select max(qty) as aa from sales) 查出等于最大值的所有记录
----------------------------------------------
-