Lines Matching refs:cnt

576   SELECT cnt, xyz, (SELECT y FROM t2 WHERE w=cnt), '|'
577     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
578    ORDER BY cnt, xyz;
581   SELECT cnt, xyz, lower((SELECT y FROM t2 WHERE w=cnt)), '|'
582     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
583    ORDER BY cnt, xyz;
586   SELECT cnt, xyz, '|'
587     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
588    WHERE (SELECT y FROM t2 WHERE w=cnt)!='two'
589    ORDER BY cnt, xyz;
592   SELECT cnt, xyz, '|'
593     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
594    ORDER BY lower((SELECT y FROM t2 WHERE w=cnt));
597   SELECT cnt, xyz, 
598          CASE WHEN (SELECT y FROM t2 WHERE w=cnt)=='two'
601     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
602    ORDER BY +cnt;
610   SELECT ( SELECT y FROM t2 WHERE z = cnt )
611     FROM ( SELECT count(*) AS cnt FROM t1 );