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.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537