github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/functions.align-only.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 min( 7 a, 8 b 9 ), 10 min( 11 DISTINCT 12 a, 13 b 14 ), 15 min(), 16 min() OVER (), 17 min() OVER ( 18 ORDER BY 19 x 20 ), 21 min() FILTER ( 22 WHERE 23 x 24 > 3 25 AND y 26 < 4 27 ), 28 min() FILTER ( 29 WHERE 30 x 31 > 3 32 AND y 33 < 4 34 ) OVER ( 35 ORDER BY 36 x 37 ), 38 min() OVER ( 39 RANGE 40 BETWEEN 41 UNBOUNDED PRECEDING 42 AND 43 UNBOUNDED FOLLOWING 44 ), 45 min() OVER ( 46 ROWS 47 BETWEEN 48 1 FOLLOWING 49 AND 50 1 FOLLOWING 51 ), 52 min() OVER ( 53 w 54 PARTITION BY 55 a, 56 b 57 ORDER BY 58 x, 59 y 60 ROWS 61 BETWEEN 62 1 FOLLOWING 63 AND 64 1 FOLLOWING 65 ) 66 67 11: 68 ----------- 69 SELECT min( 70 a, 71 b 72 ), 73 min( 74 DISTINCT 75 a, 76 b 77 ), 78 min(), 79 min() OVER (), 80 min() OVER ( 81 ORDER BY 82 x 83 ), 84 min() FILTER ( 85 WHERE 86 x 87 > 3 88 AND y 89 < 4 90 ), 91 min() FILTER ( 92 WHERE 93 x 94 > 3 95 AND y 96 < 4 97 ) OVER ( 98 ORDER BY 99 x 100 ), 101 min() OVER ( 102 RANGE 103 BETWEEN 104 UNBOUNDED PRECEDING 105 AND 106 UNBOUNDED FOLLOWING 107 ), 108 min() OVER ( 109 ROWS 110 BETWEEN 111 1 FOLLOWING 112 AND 113 1 FOLLOWING 114 ), 115 min() OVER ( 116 w 117 PARTITION BY 118 a, 119 b 120 ORDER BY 121 x, 122 y 123 ROWS 124 BETWEEN 125 1 FOLLOWING 126 AND 127 1 FOLLOWING 128 ) 129 130 15: 131 --------------- 132 SELECT min( 133 a, 134 b 135 ), 136 min( 137 DISTINCT 138 a, 139 b 140 ), 141 min(), 142 min() OVER (), 143 min() OVER ( 144 ORDER BY 145 x 146 ), 147 min() FILTER ( 148 WHERE x 149 > 3 150 AND y 151 < 4 152 ), 153 min() FILTER ( 154 WHERE x 155 > 3 156 AND y 157 < 4 158 ) OVER ( 159 ORDER BY 160 x 161 ), 162 min() OVER ( 163 RANGE 164 BETWEEN 165 UNBOUNDED PRECEDING 166 AND 167 UNBOUNDED FOLLOWING 168 ), 169 min() OVER ( 170 ROWS 171 BETWEEN 172 1 FOLLOWING 173 AND 174 1 FOLLOWING 175 ), 176 min() OVER ( 177 w 178 PARTITION BY 179 a, 180 b 181 ORDER BY 182 x, 183 y 184 ROWS 185 BETWEEN 186 1 FOLLOWING 187 AND 188 1 FOLLOWING 189 ) 190 191 16: 192 ---------------- 193 SELECT min( 194 a, 195 b 196 ), 197 min( 198 DISTINCT 199 a, 200 b 201 ), 202 min(), 203 min() OVER (), 204 min() OVER ( 205 ORDER BY 206 x 207 ), 208 min() FILTER ( 209 WHERE x 210 > 3 211 AND y 212 < 4 213 ), 214 min() FILTER ( 215 WHERE x 216 > 3 217 AND y 218 < 4 219 ) OVER ( 220 ORDER BY 221 x 222 ), 223 min() OVER ( 224 RANGE 225 BETWEEN 226 UNBOUNDED PRECEDING 227 AND 228 UNBOUNDED FOLLOWING 229 ), 230 min() OVER ( 231 ROWS 232 BETWEEN 233 1 FOLLOWING 234 AND 235 1 FOLLOWING 236 ), 237 min() OVER ( 238 w 239 PARTITION BY 240 a, b 241 ORDER BY 242 x, y 243 ROWS 244 BETWEEN 245 1 FOLLOWING 246 AND 247 1 FOLLOWING 248 ) 249 250 17: 251 ----------------- 252 SELECT min(a, b), 253 min( 254 DISTINCT 255 a, 256 b 257 ), 258 min(), 259 min() OVER (), 260 min() OVER ( 261 ORDER BY 262 x 263 ), 264 min() FILTER ( 265 WHERE x 266 > 3 267 AND y 268 < 4 269 ), 270 min() FILTER ( 271 WHERE x 272 > 3 273 AND y 274 < 4 275 ) OVER ( 276 ORDER BY 277 x 278 ), 279 min() OVER ( 280 RANGE 281 BETWEEN 282 UNBOUNDED PRECEDING 283 AND 284 UNBOUNDED FOLLOWING 285 ), 286 min() OVER ( 287 ROWS 288 BETWEEN 289 1 FOLLOWING 290 AND 291 1 FOLLOWING 292 ), 293 min() OVER ( 294 w 295 PARTITION BY 296 a, b 297 ORDER BY 298 x, y 299 ROWS 300 BETWEEN 301 1 FOLLOWING 302 AND 303 1 FOLLOWING 304 ) 305 306 18: 307 ------------------ 308 SELECT min(a, b), 309 min( 310 DISTINCT 311 a, 312 b 313 ), 314 min(), 315 min() OVER (), 316 min() OVER ( 317 ORDER BY x 318 ), 319 min() FILTER ( 320 WHERE x 321 > 3 322 AND y 323 < 4 324 ), 325 min() FILTER ( 326 WHERE x 327 > 3 328 AND y 329 < 4 330 ) OVER ( 331 ORDER BY x 332 ), 333 min() OVER ( 334 RANGE 335 BETWEEN 336 UNBOUNDED PRECEDING 337 AND 338 UNBOUNDED FOLLOWING 339 ), 340 min() OVER ( 341 ROWS 342 BETWEEN 343 1 FOLLOWING 344 AND 345 1 FOLLOWING 346 ), 347 min() OVER ( 348 w 349 PARTITION BY 350 a, b 351 ORDER BY 352 x, y 353 ROWS 354 BETWEEN 355 1 FOLLOWING 356 AND 357 1 FOLLOWING 358 ) 359 360 19: 361 ------------------- 362 SELECT min(a, b), 363 min( 364 DISTINCT 365 a, 366 b 367 ), 368 min(), 369 min() OVER (), 370 min() OVER ( 371 ORDER BY x 372 ), 373 min() FILTER ( 374 WHERE x > 3 375 AND y 376 < 4 377 ), 378 min() FILTER ( 379 WHERE x > 3 380 AND y 381 < 4 382 ) OVER ( 383 ORDER BY x 384 ), 385 min() OVER ( 386 RANGE 387 BETWEEN 388 UNBOUNDED PRECEDING 389 AND 390 UNBOUNDED FOLLOWING 391 ), 392 min() OVER ( 393 ROWS 394 BETWEEN 395 1 FOLLOWING 396 AND 397 1 FOLLOWING 398 ), 399 min() OVER ( 400 w 401 PARTITION BY 402 a, b 403 ORDER BY 404 x, y 405 ROWS 406 BETWEEN 407 1 FOLLOWING 408 AND 409 1 FOLLOWING 410 ) 411 412 20: 413 -------------------- 414 SELECT min(a, b), 415 min( 416 DISTINCT 417 a, 418 b 419 ), 420 min(), 421 min() OVER (), 422 min() OVER ( 423 ORDER BY x 424 ), 425 min() FILTER ( 426 WHERE x > 3 427 AND y 428 < 4 429 ), 430 min() FILTER ( 431 WHERE x > 3 432 AND y 433 < 4 434 ) OVER ( 435 ORDER BY x 436 ), 437 min() OVER ( 438 RANGE 439 BETWEEN 440 UNBOUNDED PRECEDING 441 AND 442 UNBOUNDED FOLLOWING 443 ), 444 min() OVER ( 445 ROWS BETWEEN 446 1 FOLLOWING 447 AND 448 1 FOLLOWING 449 ), 450 min() OVER ( 451 w 452 PARTITION BY 453 a, b 454 ORDER BY 455 x, y 456 ROWS 457 BETWEEN 458 1 FOLLOWING 459 AND 460 1 FOLLOWING 461 ) 462 463 21: 464 --------------------- 465 SELECT min(a, b), 466 min( 467 DISTINCT 468 a, 469 b 470 ), 471 min(), 472 min() OVER (), 473 min() OVER ( 474 ORDER BY x 475 ), 476 min() FILTER ( 477 WHERE x > 3 478 AND y 479 < 4 480 ), 481 min() FILTER ( 482 WHERE x > 3 483 AND y 484 < 4 485 ) OVER ( 486 ORDER BY x 487 ), 488 min() OVER ( 489 RANGE BETWEEN 490 UNBOUNDED PRECEDING 491 AND 492 UNBOUNDED FOLLOWING 493 ), 494 min() OVER ( 495 ROWS BETWEEN 496 1 FOLLOWING 497 AND 498 1 FOLLOWING 499 ), 500 min() OVER ( 501 w 502 PARTITION BY 503 a, b 504 ORDER BY 505 x, y 506 ROWS 507 BETWEEN 508 1 FOLLOWING 509 AND 510 1 FOLLOWING 511 ) 512 513 22: 514 ---------------------- 515 SELECT min(a, b), 516 min( 517 DISTINCT 518 a, 519 b 520 ), 521 min(), 522 min() OVER (), 523 min() OVER ( 524 ORDER BY x 525 ), 526 min() FILTER ( 527 WHERE x > 3 528 AND y 529 < 4 530 ), 531 min() FILTER ( 532 WHERE x > 3 533 AND y 534 < 4 535 ) OVER ( 536 ORDER BY x 537 ), 538 min() OVER ( 539 RANGE BETWEEN 540 UNBOUNDED PRECEDING 541 AND 542 UNBOUNDED FOLLOWING 543 ), 544 min() OVER ( 545 ROWS BETWEEN 546 1 FOLLOWING 547 AND 548 1 FOLLOWING 549 ), 550 min() OVER ( 551 w 552 PARTITION BY a, 553 b 554 ORDER BY x, 555 y 556 ROWS BETWEEN 557 1 FOLLOWING 558 AND 559 1 FOLLOWING 560 ) 561 562 23: 563 ----------------------- 564 SELECT min(a, b), 565 min( 566 DISTINCT 567 a, 568 b 569 ), 570 min(), 571 min() OVER (), 572 min() OVER ( 573 ORDER BY x 574 ), 575 min() FILTER ( 576 WHERE x > 3 577 AND y < 4 578 ), 579 min() FILTER ( 580 WHERE x > 3 581 AND y < 4 582 ) OVER ( 583 ORDER BY x 584 ), 585 min() OVER ( 586 RANGE BETWEEN 587 UNBOUNDED PRECEDING 588 AND 589 UNBOUNDED FOLLOWING 590 ), 591 min() OVER ( 592 ROWS BETWEEN 593 1 FOLLOWING 594 AND 595 1 FOLLOWING 596 ), 597 min() OVER ( 598 w 599 PARTITION BY a, 600 b 601 ORDER BY x, 602 y 603 ROWS BETWEEN 604 1 FOLLOWING 605 AND 606 1 FOLLOWING 607 ) 608 609 25: 610 ------------------------- 611 SELECT min(a, b), 612 min( 613 DISTINCT 614 a, 615 b 616 ), 617 min(), 618 min() OVER (), 619 min() OVER ( 620 ORDER BY x 621 ), 622 min() FILTER ( 623 WHERE x > 3 624 AND y < 4 625 ), 626 min() FILTER ( 627 WHERE x > 3 628 AND y < 4 629 ) OVER ( 630 ORDER BY x 631 ), 632 min() OVER ( 633 RANGE BETWEEN 634 UNBOUNDED PRECEDING 635 AND 636 UNBOUNDED FOLLOWING 637 ), 638 min() OVER ( 639 ROWS BETWEEN 640 1 FOLLOWING 641 AND 642 1 FOLLOWING 643 ), 644 min() OVER ( 645 w 646 PARTITION BY a, b 647 ORDER BY x, y 648 ROWS BETWEEN 649 1 FOLLOWING 650 AND 651 1 FOLLOWING 652 ) 653 654 26: 655 -------------------------- 656 SELECT min(a, b), 657 min(DISTINCT a, b), 658 min(), 659 min() OVER (), 660 min() OVER ( 661 ORDER BY x 662 ), 663 min() FILTER ( 664 WHERE x > 3 665 AND y < 4 666 ), 667 min() FILTER ( 668 WHERE x > 3 669 AND y < 4 670 ) OVER ( 671 ORDER BY x 672 ), 673 min() OVER ( 674 RANGE BETWEEN 675 UNBOUNDED PRECEDING 676 AND 677 UNBOUNDED FOLLOWING 678 ), 679 min() OVER ( 680 ROWS BETWEEN 681 1 FOLLOWING 682 AND 683 1 FOLLOWING 684 ), 685 min() OVER ( 686 w 687 PARTITION BY a, b 688 ORDER BY x, y 689 ROWS BETWEEN 690 1 FOLLOWING 691 AND 692 1 FOLLOWING 693 ) 694 695 27: 696 --------------------------- 697 SELECT min(a, b), 698 min(DISTINCT a, b), 699 min(), 700 min() OVER (), 701 min() OVER ( 702 ORDER BY x 703 ), 704 min() FILTER ( 705 WHERE x > 3 706 AND y < 4 707 ), 708 min() FILTER ( 709 WHERE x > 3 710 AND y < 4 711 ) OVER (ORDER BY x), 712 min() OVER ( 713 RANGE BETWEEN 714 UNBOUNDED PRECEDING 715 AND 716 UNBOUNDED FOLLOWING 717 ), 718 min() OVER ( 719 ROWS BETWEEN 720 1 FOLLOWING 721 AND 722 1 FOLLOWING 723 ), 724 min() OVER ( 725 w 726 PARTITION BY a, b 727 ORDER BY x, y 728 ROWS BETWEEN 729 1 FOLLOWING 730 AND 731 1 FOLLOWING 732 ) 733 734 29: 735 ----------------------------- 736 SELECT min(a, b), 737 min(DISTINCT a, b), 738 min(), 739 min() OVER (), 740 min() OVER ( 741 ORDER BY x 742 ), 743 min() FILTER ( 744 WHERE x > 3 AND y < 4 745 ), 746 min() FILTER ( 747 WHERE x > 3 AND y < 4 748 ) OVER (ORDER BY x), 749 min() OVER ( 750 RANGE BETWEEN 751 UNBOUNDED PRECEDING 752 AND 753 UNBOUNDED FOLLOWING 754 ), 755 min() OVER ( 756 ROWS BETWEEN 757 1 FOLLOWING 758 AND 759 1 FOLLOWING 760 ), 761 min() OVER ( 762 w 763 PARTITION BY a, b 764 ORDER BY x, y 765 ROWS BETWEEN 766 1 FOLLOWING 767 AND 768 1 FOLLOWING 769 ) 770 771 31: 772 ------------------------------- 773 SELECT min(a, b), 774 min(DISTINCT a, b), 775 min(), 776 min() OVER (), 777 min() OVER (ORDER BY x), 778 min() FILTER ( 779 WHERE x > 3 AND y < 4 780 ), 781 min() FILTER ( 782 WHERE x > 3 AND y < 4 783 ) OVER (ORDER BY x), 784 min() OVER ( 785 RANGE BETWEEN 786 UNBOUNDED PRECEDING 787 AND 788 UNBOUNDED FOLLOWING 789 ), 790 min() OVER ( 791 ROWS BETWEEN 792 1 FOLLOWING 793 AND 794 1 FOLLOWING 795 ), 796 min() OVER ( 797 w 798 PARTITION BY a, b 799 ORDER BY x, y 800 ROWS BETWEEN 801 1 FOLLOWING 802 AND 803 1 FOLLOWING 804 ) 805 806 32: 807 -------------------------------- 808 SELECT min(a, b), 809 min(DISTINCT a, b), 810 min(), 811 min() OVER (), 812 min() OVER (ORDER BY x), 813 min() FILTER ( 814 WHERE x > 3 AND y < 4 815 ), 816 min() FILTER ( 817 WHERE x > 3 AND y < 4 818 ) OVER (ORDER BY x), 819 min() OVER ( 820 RANGE BETWEEN 821 UNBOUNDED PRECEDING 822 AND 823 UNBOUNDED FOLLOWING 824 ), 825 min() OVER ( 826 ROWS BETWEEN 1 FOLLOWING 827 AND 1 FOLLOWING 828 ), 829 min() OVER ( 830 w 831 PARTITION BY a, b 832 ORDER BY x, y 833 ROWS BETWEEN 834 1 FOLLOWING 835 AND 836 1 FOLLOWING 837 ) 838 839 40: 840 ---------------------------------------- 841 SELECT min(a, b), 842 min(DISTINCT a, b), 843 min(), 844 min() OVER (), 845 min() OVER (ORDER BY x), 846 min() FILTER ( 847 WHERE x > 3 AND y < 4 848 ), 849 min() FILTER ( 850 WHERE x > 3 AND y < 4 851 ) OVER (ORDER BY x), 852 min() OVER ( 853 RANGE BETWEEN 854 UNBOUNDED PRECEDING 855 AND 856 UNBOUNDED FOLLOWING 857 ), 858 min() OVER ( 859 ROWS BETWEEN 1 FOLLOWING 860 AND 1 FOLLOWING 861 ), 862 min() OVER ( 863 w 864 PARTITION BY a, b 865 ORDER BY x, y 866 ROWS BETWEEN 1 FOLLOWING 867 AND 1 FOLLOWING 868 ) 869 870 41: 871 ----------------------------------------- 872 SELECT min(a, b), 873 min(DISTINCT a, b), 874 min(), 875 min() OVER (), 876 min() OVER (ORDER BY x), 877 min() FILTER ( 878 WHERE x > 3 AND y < 4 879 ), 880 min() FILTER ( 881 WHERE x > 3 AND y < 4 882 ) OVER (ORDER BY x), 883 min() OVER ( 884 RANGE BETWEEN UNBOUNDED PRECEDING 885 AND UNBOUNDED FOLLOWING 886 ), 887 min() OVER ( 888 ROWS BETWEEN 1 FOLLOWING 889 AND 1 FOLLOWING 890 ), 891 min() OVER ( 892 w 893 PARTITION BY a, b 894 ORDER BY x, y 895 ROWS BETWEEN 1 FOLLOWING 896 AND 1 FOLLOWING 897 ) 898 899 44: 900 -------------------------------------------- 901 SELECT min(a, b), 902 min(DISTINCT a, b), 903 min(), 904 min() OVER (), 905 min() OVER (ORDER BY x), 906 min() FILTER (WHERE x > 3 AND y < 4), 907 min() FILTER ( 908 WHERE x > 3 AND y < 4 909 ) OVER (ORDER BY x), 910 min() OVER ( 911 RANGE BETWEEN UNBOUNDED PRECEDING 912 AND UNBOUNDED FOLLOWING 913 ), 914 min() OVER ( 915 ROWS BETWEEN 1 FOLLOWING 916 AND 1 FOLLOWING 917 ), 918 min() OVER ( 919 w 920 PARTITION BY a, b 921 ORDER BY x, y 922 ROWS BETWEEN 1 FOLLOWING 923 AND 1 FOLLOWING 924 ) 925 926 48: 927 ------------------------------------------------ 928 SELECT min(a, b), 929 min(DISTINCT a, b), 930 min(), 931 min() OVER (), 932 min() OVER (ORDER BY x), 933 min() FILTER (WHERE x > 3 AND y < 4), 934 min() FILTER ( 935 WHERE x > 3 AND y < 4 936 ) OVER (ORDER BY x), 937 min() OVER ( 938 RANGE BETWEEN UNBOUNDED PRECEDING 939 AND UNBOUNDED FOLLOWING 940 ), 941 min() OVER ( 942 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 943 ), 944 min() OVER ( 945 w 946 PARTITION BY a, b 947 ORDER BY x, y 948 ROWS BETWEEN 1 FOLLOWING 949 AND 1 FOLLOWING 950 ) 951 952 50: 953 -------------------------------------------------- 954 SELECT min(a, b), 955 min(DISTINCT a, b), 956 min(), 957 min() OVER (), 958 min() OVER (ORDER BY x), 959 min() FILTER (WHERE x > 3 AND y < 4), 960 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 961 ORDER BY x 962 ), 963 min() OVER ( 964 RANGE BETWEEN UNBOUNDED PRECEDING 965 AND UNBOUNDED FOLLOWING 966 ), 967 min() OVER ( 968 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 969 ), 970 min() OVER ( 971 w 972 PARTITION BY a, b 973 ORDER BY x, y 974 ROWS BETWEEN 1 FOLLOWING 975 AND 1 FOLLOWING 976 ) 977 978 56: 979 -------------------------------------------------------- 980 SELECT min(a, b), 981 min(DISTINCT a, b), 982 min(), 983 min() OVER (), 984 min() OVER (ORDER BY x), 985 min() FILTER (WHERE x > 3 AND y < 4), 986 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 987 ORDER BY x 988 ), 989 min() OVER ( 990 RANGE BETWEEN UNBOUNDED PRECEDING 991 AND UNBOUNDED FOLLOWING 992 ), 993 min() OVER ( 994 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 995 ), 996 min() OVER ( 997 w 998 PARTITION BY a, b 999 ORDER BY x, y 1000 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1001 ) 1002 1003 61: 1004 ------------------------------------------------------------- 1005 SELECT min(a, b), 1006 min(DISTINCT a, b), 1007 min(), 1008 min() OVER (), 1009 min() OVER (ORDER BY x), 1010 min() FILTER (WHERE x > 3 AND y < 4), 1011 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 1012 ORDER BY x 1013 ), 1014 min() OVER ( 1015 RANGE BETWEEN UNBOUNDED PRECEDING 1016 AND UNBOUNDED FOLLOWING 1017 ), 1018 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1019 min() OVER ( 1020 w 1021 PARTITION BY a, b 1022 ORDER BY x, y 1023 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1024 ) 1025 1026 62: 1027 -------------------------------------------------------------- 1028 SELECT min(a, b), 1029 min(DISTINCT a, b), 1030 min(), 1031 min() OVER (), 1032 min() OVER (ORDER BY x), 1033 min() FILTER (WHERE x > 3 AND y < 4), 1034 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1035 min() OVER ( 1036 RANGE BETWEEN UNBOUNDED PRECEDING 1037 AND UNBOUNDED FOLLOWING 1038 ), 1039 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1040 min() OVER ( 1041 w 1042 PARTITION BY a, b 1043 ORDER BY x, y 1044 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1045 ) 1046 1047 65: 1048 ----------------------------------------------------------------- 1049 SELECT min(a, b), 1050 min(DISTINCT a, b), 1051 min(), 1052 min() OVER (), 1053 min() OVER (ORDER BY x), 1054 min() FILTER (WHERE x > 3 AND y < 4), 1055 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1056 min() OVER ( 1057 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING 1058 ), 1059 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1060 min() OVER ( 1061 w 1062 PARTITION BY a, b 1063 ORDER BY x, y 1064 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1065 ) 1066 1067 78: 1068 ------------------------------------------------------------------------------ 1069 SELECT min(a, b), 1070 min(DISTINCT a, b), 1071 min(), 1072 min() OVER (), 1073 min() OVER (ORDER BY x), 1074 min() FILTER (WHERE x > 3 AND y < 4), 1075 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1076 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1077 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1078 min() OVER ( 1079 w 1080 PARTITION BY a, b 1081 ORDER BY x, y 1082 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1083 ) 1084 1085 82: 1086 ---------------------------------------------------------------------------------- 1087 SELECT min(a, b), 1088 min(DISTINCT a, b), 1089 min(), 1090 min() OVER (), 1091 min() OVER (ORDER BY x), 1092 min() FILTER (WHERE x > 3 AND y < 4), 1093 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1094 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1095 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1096 min() OVER ( 1097 w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1098 ) 1099 1100 94: 1101 ---------------------------------------------------------------------------------------------- 1102 SELECT min(a, b), 1103 min(DISTINCT a, b), 1104 min(), 1105 min() OVER (), 1106 min() OVER (ORDER BY x), 1107 min() FILTER (WHERE x > 3 AND y < 4), 1108 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1109 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1110 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1111 min() OVER (w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) 1112 1113 393: 1114 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1115 SELECT min(a, b), min(DISTINCT a, b), min(), min() OVER (), min() OVER (ORDER BY x), min() FILTER (WHERE x > 3 AND y < 4), min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), min() OVER (w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) 1116 1117