Post reply

Sort Order

  • April 18, 2014 at 3:52 pm

    #148388

    Hi,

    I have one column in table like code.

    The table contains data like:

    01

    02

    03

    04

    05

    04A

    05A

    06

    I need to sort that data in ASC order: out put should be like:

    01

    02

    03

    04

    04A

    05

    05A

    06

  • April 18, 2014 at 4:11 pm

    #1707211

    Something like this?

    SELECT [one column] FROM table ORDER BY [one column]


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply