1. 星速云首页
  2. 阿里云文档

阿里云分析型数据库MySQL版子查询

以下示例查询门票销量排名前10的卖家,WHERE子句中包含一个表子查询,子查询生成多个行,每行包含一列数据。

表子查询可以包含多个列和行。

  1. select firstname, lastname, cityname, max(qtysold) as maxsold
  2. from users join sales on users.userid=sales.sellerid
  3. where users.cityname not in(select venuecity from venue)
  4. group by firstname, lastname, cityname
  5. order by maxsold desc, cityname desc
  6. limit 10;
  7. firstname | lastname | cityname | maxsold
  8. -----------+----------+----------------+---------
  9. Noah | Guerrero | Worcester | 8
  10. Isadora | Moss | Winooski | 8
  11. Kieran | Harrison | Westminster | 8
  12. Heidi | Davis | Warwick | 8
  13. Sara | Anthony | Waco | 8
  14. Bree | Buck | Valdez | 8
  15. Evangeline | Sampson | Trenton | 8
  16. Kendall | Keith | Stillwater | 8
  17. Bertha | Bishop | Stevens Point | 8
  18. Patricia | Anderson | South Portland | 8

注明:本文为星速云原创版权所有,禁止转载,一经发现将追究版权责任!

发表评论

登录后才能评论
问答社区 QQ客服
微信客服
微信客服
分享本页
返回顶部