这个sql可以优化么 select T.city from (select city,MAX(rank) as R from car group by city) as T order by T.R desc这个功能是正确的就是根据rank排序取city对sql不太熟感觉应该可以有更好的方法谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 写法可以简下:select city,max(rank) as r from car group by city order by r 优化就没得优化了要是慢就给city,rank 加索引 呵呵,补充一下select city,max(rank) as r from car group by city order by r desc ls的方法不行哦报错Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。 access几年没用过了access try:select city,max(rank) as r from car group by city order by max(rank) desc select city,max(rank) as r from car group by city order by r desc Select city,Max(rank) as r From car Group By city Order by r Desc Access好久没用过了,应该就是简单语法问题,查下吧 select city,max(rank) from car group by city order by max(rank) desc这样可以看来ac是没有as的 select city,max(rank) as rank from car group by city order by max(rank) desc也不行? 或select city,max(rank) rank from car group by city order by max(rank) desc 为会创建出来的数据库是只读的 关于水晶报表插入数据 谁帮我看看这句sql语句怎么写呀? c and c++是用什么开发的。 求高手解答 请问,,如何用数据库管理网站,, 怎么存取dbf文件啊? 关于数据库乱码的问题 sql2000 新对象 这句SQL语句问题在哪,一直报错! replace ,max Sql错误处理
select city,max(rank) as r from car group by city order by r
优化就没得优化了
要是慢就给city,rank 加索引
呵呵,补充一下
select city,max(rank) as r from car group by city order by r desc
报错
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
access几年没用过了
access try:select city,max(rank) as r from car group by city order by max(rank) desc
也不行?
select city,max(rank) rank from car group by city order by max(rank) desc