Lines Matching refs:LIMIT

463     SELECT * FROM t1 WHERE 1 LIMIT 1
585     SELECT * FROM t3 ORDER BY a LIMIT 3
590     SELECT * FROM t3 ORDER BY a+1 LIMIT 3
595     SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
600     SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
605     SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
610     SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
615     SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
620     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
625     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
630     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
635     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
640     SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
645     SELECT * FROM t3 WHERE a>0 ORDER BY a+1 DESC LIMIT 3
650     SELECT * FROM t3 ORDER BY b LIMIT 3
655     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
660     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
665     SELECT y FROM t1 ORDER BY w COLLATE text LIMIT 3;
670     SELECT y FROM t1 ORDER BY w COLLATE numeric LIMIT 3;
675     SELECT y FROM t1 ORDER BY w LIMIT 3;