Lines Matching refs:LIMIT

264     SELECT * FROM t1 WHERE 1 LIMIT 1
386     SELECT * FROM t3 ORDER BY a LIMIT 3
391     SELECT * FROM t3 ORDER BY a+1 LIMIT 3
396     SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
401     SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
406     SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
411     SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
416     SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
421     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
426     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
431     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c LIMIT 3
436     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC LIMIT 3
441     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c DESC LIMIT 3
446     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c DESC LIMIT 3
451     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c,a LIMIT 3
456     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c ASC LIMIT 3
461     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a ASC, c DESC LIMIT 3
466     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
471     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
476     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
481     SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
486     SELECT * FROM t3 WHERE a>0 ORDER BY -a LIMIT 3
491     SELECT * FROM t3 ORDER BY b LIMIT 3
496     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
501     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
506     SELECT y FROM t1 ORDER BY w COLLATE text LIMIT 3;
511     SELECT y FROM t1 ORDER BY w COLLATE numeric LIMIT 3;
516     SELECT y FROM t1 ORDER BY w LIMIT 3;
534     SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y LIMIT 3;
539     SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y DESC LIMIT 3;