› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
zorui
V2EX  ›  MySQL

分组查询随着时间轴变换的 sql 咋实现??

  •  
  •   zorui · Oct 25, 2016 · 4179 views
  •   You need to sign in to view this topic
    This topic created in 3633 days ago, the information mentioned may be changed or developed.

    http://ww2.sinaimg.cn/large/0060lm7Tgw1f94qukof7dj30wg0a30zm.jpg mysql 中这个表按照 position 分组查询出每组正在发布的数据(正在发布: time_updated<当前时间最近的一条) 结果要六条数据,每个位置对应着正在发布的信息。 sql 咋实现?

    1 replies  •  2016-10-25 19:45:24 +08:00
    zorui
        1
    zorui  
    OP
       Oct 25, 2016
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1386 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 16:21 · PVG 00:21 · LAX 09:21 · JFK 12:21
    ♥ Do have faith in what you're doing.