Differences

This shows you the differences between two versions of the page.

--- dbquery:ulduar10n [2025/03/23 15:56] – created ramza
+++ dbquery:ulduar10n [2025/03/23 15:57] (current) – ramza
@@ Line 1: / Line 1: @@
-select b.name
+<code sql>select b.name
  , case b.race
  when 1 then 'Human' when 2 then 'Orc' when 3 then 'Dwarf' when 4 then 'NightElf'
@@ Line 19: / Line 19: @@
  when b.race = 2 or b.race = 5 or b.race = 6 or b.race = 8 or b.race = 10 then 'Horde'
  else 'Unknown' end) = 'Alliance'
-order by class, b.name;
+order by class, b.name;</code>