I have an urgent problem. i have large table. I am trying to extract rows by a column named category and sort them by a numerical column in ascending order. I then want to insert these rows into another table.
So I am using a procedure which fetches the set of category names and get rows for that cateogry and sorts them.
However the order by does not seem to work. It does not work in other in stored procedures.
I need to solve this right away. I would really appreciate any help on this