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