- 最後登錄
- 2024-5-2
- 在線時間
- 0 小時
- 註冊時間
- 2007-6-13
- 閱讀權限
- 20
- 精華
- 0
- UID
- 1535970
- 帖子
- 168
- 積分
- 370 點
- 潛水值
- 9468 米
| 分享使你變得更實在,可以使其他人感到快樂,分享是我們的動力。今天就來分享你的資訊、圖片或檔案吧。 想請教各位大大,我要如何從以下表下sql抓取最後10筆00:20的keyboard的數量加總?
日期 | 時間 | 欄位 | 數量 | 2022/11/17 | 00:03 | keyboard | 88 | 2022/11/17 | 00:03 | mouse | 77 | 2022/11/17 | 00:03 | trumpet | 66 | 2022/11/17 | 00:03 | screen | 55 | 2022/11/17 | 00:20 | keyboard | 99 | 2022/11/17 | 00:20 | mouse | 66 | 2022/11/17 | 00:20 | trumpet | 55 | 2022/11/17 | 00:20 | screen | 33 | 2022/11/17 | 00:40 | keyboard | 22 | 2022/11/17 | 00:40 | mouse | 11 | 2022/11/17 | 00:40 | trumpet | 33 | 2022/11/17 | 00:40 | screen | 44 | 2022/11/17 | 00:55 | keyboard | 55 | 2022/11/17 | 00:55 | mouse | 66 | 2022/11/17 | 00:55 | trumpet | 77 | 2022/11/17 | 00:55 | screen | 88 | 2022/11/18 | 00:03 | keyboard | 88 | 2022/11/18 | 00:03 | mouse | 77 | 2022/11/18 | 00:03 | trumpet | 66 | 2022/11/18 | 00:03 | screen | 55 | 2022/11/18 | 00:20 | keyboard | 99 | 2022/11/18 | 00:20 | mouse | 66 | 2022/11/18 | 00:20 | trumpet | 55 | 2022/11/18 | 00:20 | screen | 33 | 2022/11/18 | 00:40 | keyboard | 22 | 2022/11/18 | 00:40 | mouse | 11 | 2022/11/18 | 00:40 | trumpet | 33 | 2022/11/18 | 00:40 | screen | 44 | 2022/11/18 | 00:55 | keyboard | 55 | 2022/11/18 | 00:55 | mouse | 66 | 2022/11/18 | 00:55 | trumpet | 77 | 2022/11/18 | 00:55 | screen | 88 | 2022/11/19 | 00:03 | keyboard | 88 | 2022/11/19 | 00:03 | mouse | 77 | 2022/11/19 | 00:03 | trumpet | 66 | 2022/11/19 | 00:03 | screen | 55 | 2022/11/19 | 00:20 | keyboard | 99 | 2022/11/19 | 00:20 | mouse | 66 | 2022/11/19 | 00:20 | trumpet | 55 | 2022/11/19 | 00:20 | screen | 33 | 2022/11/19 | 00:40 | keyboard | 22 | 2022/11/19 | 00:40 | mouse | 11 | 2022/11/19 | 00:40 | trumpet | 33 | 2022/11/19 | 00:40 | screen | 44 | 2022/11/19 | 00:55 | keyboard | 55 | 2022/11/19 | 00:55 | mouse | 66 | 2022/11/19 | 00:55 | trumpet | 77 | 2022/11/19 | 00:55 | screen | 88 | 2022/11/20 | 00:03 | keyboard | 88 | 2022/11/20 | 00:03 | mouse | 77 | 2022/11/20 | 00:03 | trumpet | 66 | 2022/11/20 | 00:03 | screen | 55 | 2022/11/20 | 00:20 | keyboard | 99 | 2022/11/20 | 00:20 | mouse | 66 | 2022/11/20 | 00:20 | trumpet | 55 | 2022/11/20 | 00:20 | screen | 33 | 2022/11/20 | 00:40 | keyboard | 22 | 2022/11/20 | 00:40 | mouse | 11 | 2022/11/20 | 00:40 | trumpet | 33 | 2022/11/20 | 00:40 | screen | 44 | 2022/11/20 | 00:55 | keyboard | 55 | 2022/11/20 | 00:55 | mouse | 66 | 2022/11/20 | 00:55 | trumpet | 77 | 2022/11/20 | 00:55 | screen | 88 | ... |
|