Lines Matching refs:ORDER
173 count {SELECT w FROM t1 WHERE w+1<=4 ORDER BY w}
306 ORDER BY 1;
313 ORDER BY 1;
320 ORDER BY 1;
327 ORDER BY 1;
332 SELECT * FROM t1 WHERE x IN (1,7) ORDER BY 1;
337 SELECT * FROM t1 WHERE x+0 IN (1,7) ORDER BY 1;
342 SELECT * FROM t1 WHERE y IN (6400,8100) ORDER BY 1;
347 SELECT * FROM t1 WHERE x=6 AND y IN (6400,8100) ORDER BY 1;
352 SELECT * FROM t1 WHERE x IN (1,7) AND y NOT IN (6400,8100) ORDER BY 1;
357 SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,10) ORDER BY 1;
373 # Check out the logic that attempts to implement the ORDER BY clause
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;
526 SELECT w FROM t1 WHERE x=3 ORDER BY y;
531 SELECT w FROM t1 WHERE x=3 ORDER BY y DESC;
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;
546 SELECT w FROM t1 WHERE x=3 AND y>121 ORDER BY y DESC;
551 SELECT w FROM t1 WHERE x=3 AND y>=121 ORDER BY y DESC;
556 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y DESC;
561 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y DESC;
566 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y DESC;
571 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y DESC;
576 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y;
581 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y;
586 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y;
591 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y;
596 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y;
601 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y;
606 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y;
611 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y;
616 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y DESC;
621 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y DESC;
626 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y DESC;
631 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y DESC;
636 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y;
641 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y;
646 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y;
651 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y;
656 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y DESC;
661 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y DESC;
666 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y DESC;
671 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y DESC;
681 SELECT w FROM t4 WHERE x=4 and y<1000 ORDER BY y DESC limit 3;
689 SELECT w FROM t4 WHERE x=4 and y<1000 ORDER BY y DESC limit 3;
703 SELECT * FROM t5 WHERE x<10 ORDER BY x DESC;