--這個算不算，呵呵
with t(num)as(
select 1 union select 2 union all select 3)
select t1.num*10+t2.num result from t t1,t t2
where t1.num<>t2.num
order by result
/*
result
-----------
12
13
21
23
31
32

(6 row(s) affected)
*/