本文共 665 字,大约阅读时间需要 2 分钟。
??????????????????????
| ?? | ?? |
|---|---|
| ??? | 22 |
| ?? | 12 |
| ?? | 5 |
| ??? | 15 |
| ??? | 27 |
| ?? | 26 |
| ?? | 22 |
| ????????? | 29 |
| ???? | 12 |
| ?? | 21 |
| ??? | 6 |
| ???? | 11 |
| ????? | 18 |
| ?????? | 12 |
| ?? | 7 |
| ????? | 19 |
| ?? | 18 |
| ?? | 23 |
| ?????? | 5 |
| ?????? | 27 |
| ?? | 11 |
| ????? | 28 |
| ?? | 4 |
| ???? | 19 |
| 12V????? | 8 |
| ??? | 19 |
| ??? | 16 |
| ?? | 7 |
| ??? | 12 |
| ?? | 29 |
??INT????????????????????SQL?????
SELECT ??, ??, INT(??/8) AS ?????? FROM [sheet1$]
INT???????????????????????????
INT(??/8)
?????18??18/8=2.25?INT?????2?
??FIX????????????????????SQL?????
SELECT ??, ??, FIX(??/8) AS ?????? FROM [sheet1$]
FIX???INT?????????????????????????INT?FIX???????????????
FIX(18/8) = FIX(2.25) = 2
??????
INT(-2.25) = -3FIX(-2.25) = -2
?????INT??FIX????????
转载地址:http://gggn.baihongyu.com/