SELECT * FROM
(SELECT a.id,a.catid,a.title,a.thumb,a.description,a.pinpai,b.count,b.posnum FROM buses17_brand AS a LEFT JOIN buses17_statistics_res AS b ON a.id=b.cxid where a.catid = 38 and b.type=2 and (a.energy like ‘%纯电动%‘ or a.energy like ‘%混合动力%‘ or a.energy like ‘%燃料电池%‘) ORDER BY posnum DESC,count DESC limit 100)temp
GROUP BY temp. pinpai order by posnum desc,count desc
相关文章
- 01-16每日笔记:2020.10.28
- 01-16SQL在数据处理过程中,遇到除数为0该怎么办?
- 01-16SQL语句将两个select语句查询结果合并一个
- 01-16从"UDF不应有状态" 切入来剖析Flink SQL代码生成
- 01-16Python基础教程【读书笔记】 - 2016/7/7
- 01-16C++ Primer 学习笔记_85_模板与泛型编程 --模板特化[续]
- 01-16ruoyi偌衣学习笔记
- 01-16嵌入式开发笔记——MCU配置Altera-Cyclone系列FPGA(PS)
- 01-16SQL 无法解决 EQUAL TO 运算中 "CHINESE_PRC_CI_AS" 和 "CHINESE_PRC_90_CI_AI" 之间的排序规则冲突
- 01-16sql中,In和where的区别