test
Sql
code posted
created at 12 Aug 10:51
Edit
|
Back
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SELECT NULL object_id, 'CO2_AT' AS object_name, 873 AS type_id, qu_deliverydate_local AS start_date, LAST_DAY (qu_deliverydate_local) AS end_date, 0 AS e_min, 0 AS e_max, qu_tradedate_local AS update_date, NULL AS e_cons, qu_value AS price_emm_purch, 0 AS price_emm_sale FROM ADB.ADB_QUOTE WHERE qu_ts_id = 5372 ORDER BY update_date DESC, start_date ASC; |
494 Bytes in 2 ms with coderay