ROW_NUMBER() OVER (PARTITION BY 字段1 ORDER BY 字段2 DESC)
number by 字段 order partition row Over desc
2023-09-14 09:09:30 时间
这个用法在mysql 中没有,就是对数据先根据字段1聚合,在根据字段二排序
select * from (
SELECT player_id , DATE(timestamp ) as dt ,ROW_NUMBER() OVER (PARTITION BY player_id ORDER BY timestamp DESC) AS rn, FROM `heidao-market.mafia1_ods.game_log_login`
WHERE DATE(timestamp) >= '2020-01-10' and DATE(timestamp) <= '2020-01-11')
where rn= 1
相关文章
- SQL | 窗口函数 row number + partition by 排序
- oracle中number的用法,Oracle Number数字
- 8c 数据库,MySQL数据库5.8以上与以下版本,Oracle数据库实现row_number() over(partition by 分组列 order by 排序列 desc)
- SAP QM QS21创建检验特性,报错- Number range interval 01 for number range object QMERKMALE
- ORA-19283: XQST0031 – It is a static error if the version number specified in a version declaration is not supported by the implementation. ORACLE 报错 故障修复 远程处理
- ORA-19756: corrupt block number string found in change tracking file ORACLE 报错 故障修复 远程处理
- MySQL Error number: 3179; Symbol: ER_MASTER_KEY_ROTATION_NOT_SUPPORTED_BY_SE; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 3566; Symbol: ER_NO_ACCESS_TO_NATIVE_FCT; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 3602; Symbol: ER_FIELD_IN_GROUPING_NOT_GROUP_BY; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 3746; Symbol: ER_TEMP_TABLE_PREVENTS_SWITCH_GLOBAL_BINLOG_FORMAT; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 3855; Symbol: ER_DEPENDENT_BY_PARTITION_FUNC; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 3885; Symbol: ER_DA_UNKNOWN_ERROR_NUMBER; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: 4007; Symbol: ER_REGEX_NUMBER_TOO_BIG; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010154; Symbol: ER_RPL_REWRITEDB_EMPTY_FROM; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010233; Symbol: ER_TRX_GTID_COLLECT_REJECT; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010537; Symbol: ER_RPL_RECOVERY_ERROR; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010815; Symbol: ER_BINLOG_FILE_EXTENSION_NUMBER_RUNNING_LOW; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010894; Symbol: ER_NDB_NUMBER_OF_CHANNELS; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011515; Symbol: ER_GRP_RPL_DATA_NOT_PROVIDED_BY_MEM; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011606; Symbol: ER_GRP_RPL_FAILED_TO_EXTRACT_TRANS_WRITE_SET; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011672; Symbol: ER_GRP_RPL_ABORTS_AS_SSL_NOT_SUPPORTED_BY_MYSQLD; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-07339: spcre: maximum number of semaphore sets exceeded. ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-012085; Symbol: ER_IB_MSG_260; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-012857; Symbol: ER_IB_MSG_1032; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-013395; Symbol: ER_IB_MSG_DDL_LOG_DELETE_BY_ID_TMCT; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-013474; Symbol: ER_GRP_RPL_SLAVE_THREAD_ERROR_ON_CLONE; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-013608; Symbol: ER_IB_MSG_TRX_RECOVERY_ROLLBACK_NOT_COMPLETED; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-013973; Symbol: ER_BULK_PARSER_MISSING_ENCLOSED_BY_LOG; SQLSTATE: HY000 报错 故障修复 远程处理
- [by 王谭] ROW_NUMBER() OVER() 分析函数的用法详解数据库