Lines Matching refs:LIMIT

465     SELECT * FROM t1 WHERE 1 LIMIT 1
587     SELECT * FROM t3 ORDER BY a LIMIT 3
592     SELECT * FROM t3 ORDER BY a+1 LIMIT 3
597     SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
602     SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
607     SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
612     SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
617     SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
622     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
627     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
632     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
637     SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
642     SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
647     SELECT * FROM t3 WHERE a>0 ORDER BY a+1 DESC LIMIT 3
652     SELECT * FROM t3 ORDER BY b LIMIT 3
657     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
662     SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
667     SELECT y FROM t1 ORDER BY w COLLATE text LIMIT 3;
672     SELECT y FROM t1 ORDER BY w COLLATE numeric LIMIT 3;
677     SELECT y FROM t1 ORDER BY w LIMIT 3;