locked
ORACLE query RRS feed

  • Question

  • User1449453972 posted

    below is my table t1

     C1    

    -----

    Ca    

    Cb

    Cc       

    Cd     

    Ce       

    Cf

    Cg

    Please help me to write oracle query to output the following

    C1    

    -----

    Ca    

    Cc       

    Ce       

    Cg

    Friday, July 26, 2013 5:58 AM

Answers

  • User1424224880 posted

    Try something like this.

    SELECT *
     FROM
     (SELECT rownum AS rn, c1
     FROM column)
     WHERE MOD(rn,2)<>0



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 26, 2013 7:15 AM