Days Wise Data

  • hi,

    my data looks like this

    days---------visit

    5--------------1

    10-------------10

    1--------------2

    i want this type of data

    days---------visit

    1--------------1

    5--------------1

    10--------------10

    plesae help me out

    thanks for the help

    immad

  • immaduddinahmed (7/13/2015)


    hi,

    my data looks like this

    days---------visit

    5--------------1

    10-------------10

    1--------------2

    i want this type of data

    days---------visit

    1--------------1

    5--------------1

    10--------------10

    plesae help me out

    thanks for the help

    The data in your results is different from the initial data. You've got 1 in the visits column twice. If that's a mistake, then you need to put this at the end of your query.

    ORDER BY days

    If it's not a mistake, we're going to need a bit more help.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

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

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