kiltum (kiltum) wrote,
kiltum
kiltum

mysql> select min(tmp) from temp;
+------------------+
| min(tmp)         |
+------------------+
| -28.190000534058 |
+------------------+
1 row in set (0.20 sec)

mysql> select dta,tmp from temp where tmp< -28;
+---------------------+--------+
| dta                 | tmp    |
+---------------------+--------+
| 2006-01-18 05:58:06 | -28.06 |
| 2006-01-18 06:24:06 | -28.19 |
| 2006-01-18 08:10:07 | -28.12 |
| 2006-01-18 08:14:06 | -28.06 |
| 2006-01-18 08:18:07 | -28.19 |
| 2006-01-18 08:26:06 | -28.06 |
+---------------------+--------+
6 rows in set (0.20 sec)

mysql>
Как это ... поздравляю вас с самым холодным днем в москве за 2 года. (может и больше, но логи ведутся с прошлого НГ)
Subscribe
  • Post a new comment

    Error

    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments