Days Wise Data

• immaduddinahmed

  Ten Centuries

  Points: 1375

  More actions

  July 13, 2015 at 1:08 am

  #305691

  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

• Neil Burton

  SSC-Insane

  Points: 23002

  More actions

  July 13, 2015 at 1:37 am

  #1811869

  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