• Hi Sashi,

    Please find below query for this.. this is so simple query..

    SELECT houseno

    FROM test

    order by houseno