Lines Matching refs:LIMIT

266     SELECT * FROM t1 WHERE 1 LIMIT 1
388 SELECT * FROM t3 ORDER BY a LIMIT 3
393 SELECT * FROM t3 ORDER BY a+1 LIMIT 3
398 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
403 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
408 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
413 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
418 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
423 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
428 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
433 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c LIMIT 3
438 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC LIMIT 3
443 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c DESC LIMIT 3
448 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c DESC LIMIT 3
453 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY c,a LIMIT 3
458 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a DESC, c ASC LIMIT 3
463 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a ASC, c DESC LIMIT 3
468 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
473 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
478 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
483 SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
488 SELECT * FROM t3 WHERE a>0 ORDER BY -a LIMIT 3
493 SELECT * FROM t3 ORDER BY b LIMIT 3
498 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
503 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
508 SELECT y FROM t1 ORDER BY w COLLATE text LIMIT 3;
513 SELECT y FROM t1 ORDER BY w COLLATE numeric LIMIT 3;
518 SELECT y FROM t1 ORDER BY w LIMIT 3;
536 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y LIMIT 3;
541 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y DESC LIMIT 3;