我要用SQl语句取得A，B字段的和的最大一条数据，也就是第二条1+55=56，或者其它办法！先谢了！select A.num,B.num from A,B where (A.num+B.num) in(select max(A.num+B.num) from A,B) select * from 表1 t where not exists(select 1 from 表1 where (A+B)>(t.A+t.B)); select * from 表1 where A+B=(select max(A+B) from 表1); 第二条是不是2+55啊？没看明白 SQL code:
select * from 表一 where exists(select 1 from 表一 where right(A,INSTR(A,''))>where right(b,INSTR(b,'')))
饿 写错了 SQL code:
select from 表一 t where right(A,INSTR(A,''))+right(B,INSTR(B,''))>right(t.A,INSTR(t.A,''))+right(t.B,INSTR(t.B,''))
SQL code:
select *from 表一 t where ( right(A,INSTR(A,''))+right(B,INSTR(B,'')))>(right(t.A,INSTR(t.A,''))+right(t.B,INSTR(t.B,'')));
