Lines Matching refs:x
161 SELECT 123 AS x ORDER BY (SELECT x ORDER BY 1);
445 SELECT 1 UNION SELECT 2 AS 'x'
446 ORDER BY x;
452 SELECT 1 UNION ALL SELECT 2 AS 'x'
453 ORDER BY x;
497 CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
498 SELECT * FROM t2 ORDER BY x;
504 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 INTERSECT SELECT x FROM t2)
510 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 EXCEPT SELECT x FROM t2)
516 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 UNION SELECT x FROM t2)
554 SELECT x, y FROM t2 UNION SELECT a, b FROM t3 ORDER BY x LIMIT 1
556 } {x 0 y 1}
559 SELECT x, y FROM t2 UNION ALL SELECT a, b FROM t3 ORDER BY x LIMIT 1
561 } {x 0 y 1}
564 SELECT x, y FROM t2 EXCEPT SELECT a, b FROM t3 ORDER BY x LIMIT 1
566 } {x 0 y 1}
569 SELECT x, y FROM t2 INTERSECT SELECT 0 AS a, 1 AS b;
571 } {x 0 y 1}
574 SELECT 0 AS x, 1 AS y
579 ORDER BY x LIMIT 1
581 } {x 0 y 1}
587 SELECT 0 AS x, 1 AS y
594 } {x 0 y 1}
598 SELECT 0 AS x, 1 AS y
603 ) ORDER BY x LIMIT 1;
605 } {x 0 y 1}
610 SELECT 0 AS x, 1 AS y
612 SELECT 2 AS y, -3 AS x
613 ORDER BY x LIMIT 1;
704 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
706 SELECT x FROM t2
711 SELECT x FROM t2
713 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
718 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
720 SELECT x FROM t2
725 SELECT x FROM t2
727 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
732 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
734 SELECT x FROM t2
739 SELECT x FROM t2
741 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
746 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
748 SELECT x FROM t2
753 SELECT x FROM t2
755 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
761 SELECT x FROM t2
763 SELECT x FROM t2
765 SELECT x FROM t2
767 SELECT x FROM t2
769 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
774 SELECT x FROM t2
776 SELECT x FROM t2
778 SELECT x FROM t2
780 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
782 SELECT x FROM t2
787 SELECT x FROM t2
789 SELECT x FROM t2
791 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
793 SELECT x FROM t2
795 SELECT x FROM t2
800 SELECT x FROM t2
802 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
804 SELECT x FROM t2
806 SELECT x FROM t2
808 SELECT x FROM t2
813 SELECT x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x,x FROM t2
815 SELECT x FROM t2
817 SELECT x FROM t2
819 SELECT x FROM t2
821 SELECT x FROM t2
943 CREATE TABLE t1(a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,
946 WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
948 SELECT x%10, x/10, x, printf('xyz%dabc',x) FROM c;
984 SELECT x, y FROM (
985 SELECT 98 AS x, 99 AS y
987 SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a
989 ORDER BY +x;
992 SELECT x, y FROM (
993 SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a
995 SELECT 98 AS x, 99 AS y
997 ORDER BY +x;
1000 SELECT x, y FROM (
1001 SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a LIMIT 3
1003 SELECT 98 AS x, 99 AS y
1005 ORDER BY +x;
1038 CREATE TABLE t1(x);
1040 SELECT sum((SELECT 1 FROM (SELECT 2 WHERE x IS NULL) WHERE 0)) FROM t1;