Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Irregular Sort within SQL
How can I sort this resultset so that a column named itmlabel that corresponds to textid will come in the order 'B', 'R', 'E', 'V'? SELECT DISTINCT a.itemtype, c.textid, c.min, c.max, rtrim(c.header) as header FROM ONLINETST.vdepts d, ONLINETST.item a, ONLINETST.text c WHERE... -
ORDER BY CASE
How would I change this query that I am running from my servlet so that it takes out the duplicates of B and R just like it is currently doing, but then also combines E and V and removes their duplicates and orders them by E then V? I can add them together with the following code, but cannot...
