这样的问题怎样用sql语句实现?? insert into b (select * from a join b on a.id=b.id where a.field>b.field) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 怎么选出a表中某个字段值(aa)最大的纪录:我这样写,但是报错select * from a where a.aa=max(a.aa) 这样select * from a where a.aa = (select max(a.aa) from a) 或则select * from a where a.aa in (select max(a.aa) from a) 这样select * from a where a.aa = (select max(a.aa) from a) 或则select * from a where a.aa in (select max(a.aa) from a) insert into b (select * from a, (select max(aa) as m_aa from a) as b where a.aa = b.m_aa) insert into b(要插入的字段,,,,) values(select max(a.aa) from a, ,,) 计算总数 一张表中多个索引问题? 用游标更新记录,3个字段id,date,dateid,id是顺序的,date是没有顺序的日期,要更新dateid(按date分组按id排序+0000的流水号) 一次性删除一个数据库里面所有表的外键约束 简单问题,快来抢分啊!!先来先得!!利马揭帖!!! 关于 JOIN 语句条件的筛选优化问题 高分跪求一个问题!!在线等待 sql 局部变量无法得到值 求数据库中一个表自动更新方法,在线等 可不可以在存储过程里调用打印机,然后打印某些字段的内容啊? 救命啊,各位大虾救救小弟吧!!! An error 1069 (由于登录而无法启动服务器)
我这样写,但是报错
select * from a where a.aa=max(a.aa)
select * from a where a.aa in (select max(a.aa) from a)
select * from a where a.aa in (select max(a.aa) from a)
(select * from a, (select max(aa) as m_aa from a) as b
where a.aa = b.m_aa)