Order by and have one value always on top
Posted on 2010-08-23
I want to select and order it such a way that SHOPN is always on top. What I did was to add another column to this table and added ID and ordered it by
ID (added 1 for SHOPN, 2 for NBW, 3 for PFF, 4 for Warr)
That's an over kill. Is there any other way to always have SHOPN on top? I dont want to use the Sale column..that might change.