010.Oracle数据库 , ORDER BY 按升序降序排序

            /*
            Oracle数据库查询日期在两者之间
            */
            SELECT
            DISTINCT
             ATA

            FROM
            
    LM_FAULT 

            WHERE
            
    ( 
        OCCUR_DATE 
            BETWEEN to_date( ‘2017-05-01‘, ‘yyyy-MM-DD‘ ) AND to_date( ‘2017-05-15‘, ‘yyyy-MM-DD‘ )        
    )
    ORDERBY ATA DESC     
;