I Want to retrieve data from database by ascending order. In Database numbers are stored as
1 2 3 1 2 3 1 1 2 3 4 .... 10
but when i run my query then it show as
1 1 1 1
10 2 2 3 3 3 4
My query is
SELECT * FROM tblDetail
WHERE USERID = @uID
ORDER BY day ASC
Here day is number 1 2 3 4 etc
i.e on day 1 on day 2
[Edit]Code block added[/Edit]