906
906
SELECT p.a AS val, q.a AS val FROM t1 p, t1 q ORDER BY val > 1;
907
907
ERROR 23000: Column 'val' in order clause is ambiguous
909
CREATE TABLE t1 (a int);
910
INSERT INTO t1 VALUES (3), (2), (4), (1);
911
SELECT a, IF(a IN (2,3), a, a+10) FROM t1
912
ORDER BY IF(a IN (2,3), a, a+10);
913
a IF(a IN (2,3), a, a+10)
918
SELECT a, IF(a NOT IN (2,3), a, a+10) FROM t1
919
ORDER BY IF(a NOT IN (2,3), a, a+10);
920
a IF(a NOT IN (2,3), a, a+10)
925
SELECT a, IF(a IN (2,3), a, a+10) FROM t1
926
ORDER BY IF(a NOT IN (2,3), a, a+10);
927
a IF(a IN (2,3), a, a+10)
932
SELECT a, IF(a BETWEEN 2 AND 3, a, a+10) FROM t1
933
ORDER BY IF(a BETWEEN 2 AND 3, a, a+10);
934
a IF(a BETWEEN 2 AND 3, a, a+10)
939
SELECT a, IF(a NOT BETWEEN 2 AND 3, a, a+10) FROM t1
940
ORDER BY IF(a NOT BETWEEN 2 AND 3, a, a+10);
941
a IF(a NOT BETWEEN 2 AND 3, a, a+10)
946
SELECT a, IF(a BETWEEN 2 AND 3, a, a+10) FROM t1
947
ORDER BY IF(a NOT BETWEEN 2 AND 3, a, a+10);
948
a IF(a BETWEEN 2 AND 3, a, a+10)
953
SELECT IF(a IN (1,2), a, '') as x1, IF(a NOT IN (1,2), a, '') as x2
954
FROM t1 GROUP BY x1, x2;
960
SELECT IF(a IN (1,2), a, '') as x1, IF(a NOT IN (1,2), a, '') as x2
961
FROM t1 GROUP BY x1, IF(a NOT IN (1,2), a, '');
967
SELECT a, a IN (1,2) FROM t1 ORDER BY a IN (1,2);
973
SELECT a FROM t1 ORDER BY a IN (1,2);
979
SELECT a+10 FROM t1 ORDER BY a IN (1,2);
985
SELECT a, IF(a IN (1,2), a, a+10) FROM t1
986
ORDER BY IF(a IN (3,4), a, a+10);
987
a IF(a IN (1,2), a, a+10)
909
993
create table t1 (a int not null, b int not null, c int not null);
910
994
insert t1 values (1,1,1),(1,1,2),(1,2,1);
911
995
select a, b from t1 group by a, b order by sum(c);
952
1036
DROP TABLE t1,t2,t3,t4;
1037
create table t1 (a int, b int, c int);
1038
insert into t1 values (1,2,3), (9,8,3), (19,4,3), (1,4,9);
1039
select a,(sum(b)/sum(c)) as ratio from t1 group by a order by sum(b)/sum(c) asc;
1045
CREATE TABLE t1 (a INT UNSIGNED NOT NULL, b TIME);
1046
INSERT INTO t1 (a) VALUES (100000), (0), (100), (1000000),(10000), (1000), (10);
1047
UPDATE t1 SET b = SEC_TO_TIME(a);
1048
SELECT a, b FROM t1 ORDER BY b DESC;
1057
SELECT a, b FROM t1 ORDER BY SEC_TO_TIME(a) DESC;
953
1067
CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a), UNIQUE KEY b (b));
954
1068
INSERT INTO t1 VALUES (1,1),(2,2);
955
1069
CREATE TABLE t2 (a INT, b INT, KEY a (a,b));