Ikarosx's recent timeline updates Ikarosx's recent timeline updates |
IkarosxV2EX member #609376, joined on 2023-01-06 09:27:14 +08:00 |
Ikarosx's recent replies
Aug 8, 2023 Replied to a topic by ozeer › 程序员 › Boss 直聘 APP 端为什么通过 Charles 之类的软件完全抓不到页面请求的接口（其他的 APP 有的是可以抓取到 https 接口的）？这种连接口都抓不到的都是采用服务端端渲染的方式吗？还是有别的什么处理？ |
3 楼正解，尝试使用 Drony 走 vpn ，Magisk + LSPosed + Drony + TrusetMe 类的模块
Mar 28, 2023 Replied to a topic by godleon › 程序员 › 请教一个数据处理的需求，寻一个高效率的解决方法？ |
mark 一下，看看有没有更好的方式
```sql
SELECT DISTINCT
DATE_FORMAT( DATE, '%Y-%m-%d' ) day,
type,
COUNT(*) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ) count,
FIRST_VALUE( DATE ) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ORDER BY DATE DESC ) date,
FIRST_VALUE( VALUE ) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ORDER BY DATE DESC ) value
FROM
test
```
```sql
SELECT DISTINCT
DATE_FORMAT( DATE, '%Y-%m-%d' ) day,
type,
COUNT(*) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ) count,
FIRST_VALUE( DATE ) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ORDER BY DATE DESC ) date,
FIRST_VALUE( VALUE ) OVER ( PARTITION BY DATE_FORMAT( DATE, '%Y-%m-%d' ), type ORDER BY DATE DESC ) value
FROM
test
```
Select Language