My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

rymo

By: a guest | Feb 1st, 2010 | Syntax: MySQL | Size: 0.79 KB | Hits: 85 | Expires: Never
Download | Raw | Embed | Report abuse
This paste has a previous version, view the difference. Copy text to clipboard
  1. SELECT MAX(`HourEnding`) FROM `lmp_hourly` WHERE `RTStatus` = 'final';
  2. #+---------------------+
  3. #| MAX(`HourEnding`)   |
  4. #+---------------------+
  5. #| 2010-01-28 22:59:59 |
  6. #+---------------------+
  7. #1 row in set (0.00 sec)
  8.  
  9. SELECT MAX(`HourEnding`) FROM `lmp_hourly` WHERE `RTStatus` = 'prelim';
  10. +---------------------+
  11. | MAX(`HourEnding`)   |
  12. +---------------------+
  13. | 2010-01-30 22:59:59 |
  14. +---------------------+
  15. 1 row in set (0.00 sec)
  16.  
  17. mysql> SELECT MAX(`he`) FROM ((SELECT MAX(`HourEnding`) `he` FROM `lmp_hourly` WHERE `RTStatus` = 'prelim') UNION (SELECT MAX(`HourEnding`) `he` FROM `lmp_hourly` WHERE `RTStatus` = 'final')) `t`;
  18. +---------------------+
  19. | MAX(`he`)           |
  20. +---------------------+
  21. | 2010-01-30 22:59:59 |
  22. +---------------------+
  23. 1 row in set (0.00 sec)
create new paste | create new version of this paste RAW Paste Data