SQL Editor

SQL Between Example

Task:

List all orders between $1000 and $2000.
Click here for details on Between.
 
 208 Records
OrderDate OrderNumber TotalAmount
4/28/2022 12:00:00 AM 542379 1863.40
5/1/2022 12:00:00 AM 542380 1813.00
5/3/2022 12:00:00 AM 542383 1444.80
5/9/2022 12:00:00 AM 542387 1119.90
5/12/2022 12:00:00 AM 542390 1746.20
5/18/2022 12:00:00 AM 542395 1176.00
5/23/2022 12:00:00 AM 542398 1101.20
5/25/2022 12:00:00 AM 542400 1376.00
5/26/2022 12:00:00 AM 542402 1456.00
6/2/2022 12:00:00 AM 542407 1200.80
6/5/2022 12:00:00 AM 542408 1488.80
6/9/2022 12:00:00 AM 542413 1414.80
6/12/2022 12:00:00 AM 542414 1452.00
6/21/2022 12:00:00 AM 542422 1296.00
6/23/2022 12:00:00 AM 542424 1887.60
6/27/2022 12:00:00 AM 542426 1050.60
6/28/2022 12:00:00 AM 542427 1420.00
7/5/2022 12:00:00 AM 542433 1242.00
7/13/2022 12:00:00 AM 542439 1762.00
7/17/2022 12:00:00 AM 542442 1614.80
7/26/2022 12:00:00 AM 542449 1191.20
8/2/2022 12:00:00 AM 542455 1497.00
8/7/2022 12:00:00 AM 542458 1168.00
8/9/2022 12:00:00 AM 542460 1940.00
8/24/2022 12:00:00 AM 542473 1586.00
8/29/2022 12:00:00 AM 542476 1731.20
9/11/2022 12:00:00 AM 542486 1106.40
9/12/2022 12:00:00 AM 542487 1360.00
9/18/2022 12:00:00 AM 542492 1549.60
9/22/2022 12:00:00 AM 542498 1834.20
9/26/2022 12:00:00 AM 542500 1174.00
9/28/2022 12:00:00 AM 542503 1708.00
10/2/2022 12:00:00 AM 542507 1016.00
10/5/2022 12:00:00 AM 542510 1419.80
10/11/2022 12:00:00 AM 542517 1058.40
10/12/2022 12:00:00 AM 542518 1274.00
10/13/2022 12:00:00 AM 542519 1832.80
10/17/2022 12:00:00 AM 542522 1440.00
10/20/2022 12:00:00 AM 542526 1903.80
10/24/2022 12:00:00 AM 542529 1765.60
10/27/2022 12:00:00 AM 542533 1005.90
10/27/2022 12:00:00 AM 542534 1675.00
10/31/2022 12:00:00 AM 542537 1194.00
11/1/2022 12:00:00 AM 542538 1622.40
11/3/2022 12:00:00 AM 542541 1208.50
11/10/2022 12:00:00 AM 542548 1814.80
11/14/2022 12:00:00 AM 542550 1897.60
11/14/2022 12:00:00 AM 542551 1273.20
11/16/2022 12:00:00 AM 542553 1020.00
11/22/2022 12:00:00 AM 542559 1748.50
12/1/2022 12:00:00 AM 542569 1078.00
12/4/2022 12:00:00 AM 542571 1755.00
12/5/2022 12:00:00 AM 542572 1792.00
12/6/2022 12:00:00 AM 542574 1031.70
12/12/2022 12:00:00 AM 542579 1838.20
12/19/2022 12:00:00 AM 542587 1584.00
12/21/2022 12:00:00 AM 542589 1688.00
12/26/2022 12:00:00 AM 542594 1848.00
1/1/2023 12:00:00 AM 542599 1125.50
1/2/2023 12:00:00 AM 542600 1820.80
1/2/2023 12:00:00 AM 542601 1328.00
1/3/2023 12:00:00 AM 542602 1051.20
1/4/2023 12:00:00 AM 542604 1249.10
1/5/2023 12:00:00 AM 542605 1770.80
1/11/2023 12:00:00 AM 542611 1472.00
1/16/2023 12:00:00 AM 542615 1760.00
1/17/2023 12:00:00 AM 542616 1272.00
1/18/2023 12:00:00 AM 542618 1560.00
1/26/2023 12:00:00 AM 542627 1380.60
1/30/2023 12:00:00 AM 542629 1412.00
2/2/2023 12:00:00 AM 542634 1388.50
2/26/2023 12:00:00 AM 542656 1344.00
2/26/2023 12:00:00 AM 542657 1670.00
3/7/2023 12:00:00 AM 542667 1823.80
3/14/2023 12:00:00 AM 542673 1770.00
3/16/2023 12:00:00 AM 542677 1908.00
3/21/2023 12:00:00 AM 542681 1836.00
3/23/2023 12:00:00 AM 542683 1546.30
3/23/2023 12:00:00 AM 542684 1819.50
3/27/2023 12:00:00 AM 542687 1152.50
3/30/2023 12:00:00 AM 542690 1257.30
4/3/2023 12:00:00 AM 542694 1299.00
4/11/2023 12:00:00 AM 542702 1565.65
4/19/2023 12:00:00 AM 542710 1067.10
4/30/2023 12:00:00 AM 542720 1140.00
5/4/2023 12:00:00 AM 542726 1476.10
5/11/2023 12:00:00 AM 542733 1508.00
5/15/2023 12:00:00 AM 542736 1413.00
5/16/2023 12:00:00 AM 542738 1064.00
5/24/2023 12:00:00 AM 542747 1650.00
5/28/2023 12:00:00 AM 542749 1260.00
5/31/2023 12:00:00 AM 542753 1429.75
5/31/2023 12:00:00 AM 542754 1393.24
6/4/2023 12:00:00 AM 542756 1503.60
6/4/2023 12:00:00 AM 542757 1264.50
6/11/2023 12:00:00 AM 542765 1380.25
6/18/2023 12:00:00 AM 542773 1086.00
6/18/2023 12:00:00 AM 542774 1422.00
6/19/2023 12:00:00 AM 542775 1535.00
6/20/2023 12:00:00 AM 542776 1928.00
6/21/2023 12:00:00 AM 542779 1434.00
6/22/2023 12:00:00 AM 542780 1820.20
6/26/2023 12:00:00 AM 542783 1203.50
6/29/2023 12:00:00 AM 542789 1291.60
7/2/2023 12:00:00 AM 542790 1701.00
7/4/2023 12:00:00 AM 542794 1515.75
7/5/2023 12:00:00 AM 542795 1295.00
7/6/2023 12:00:00 AM 542797 1921.00
7/13/2023 12:00:00 AM 542805 1423.00
7/18/2023 12:00:00 AM 542810 1682.50
7/19/2023 12:00:00 AM 542811 1327.00
7/20/2023 12:00:00 AM 542814 1768.00
7/24/2023 12:00:00 AM 542816 1638.45
7/26/2023 12:00:00 AM 542820 1150.00
8/1/2023 12:00:00 AM 542827 1073.90
8/9/2023 12:00:00 AM 542836 1893.00
8/9/2023 12:00:00 AM 542837 1704.00
8/14/2023 12:00:00 AM 542842 1238.40
8/16/2023 12:00:00 AM 542845 1296.00
8/17/2023 12:00:00 AM 542847 1331.75
8/20/2023 12:00:00 AM 542849 1125.67
8/22/2023 12:00:00 AM 542852 1570.00
8/27/2023 12:00:00 AM 542857 1710.00
8/28/2023 12:00:00 AM 542858 1296.75
8/28/2023 12:00:00 AM 542859 1850.00
8/30/2023 12:00:00 AM 542861 1990.00
8/31/2023 12:00:00 AM 542863 1459.00
8/31/2023 12:00:00 AM 542864 1498.35
9/6/2023 12:00:00 AM 542870 1770.00
9/12/2023 12:00:00 AM 542877 1912.85
9/13/2023 12:00:00 AM 542879 1080.00
9/14/2023 12:00:00 AM 542880 1871.25
9/17/2023 12:00:00 AM 542881 1701.46
9/21/2023 12:00:00 AM 542888 1644.60
9/27/2023 12:00:00 AM 542895 1684.00
10/1/2023 12:00:00 AM 542898 1477.00
10/1/2023 12:00:00 AM 542899 1704.00
10/9/2023 12:00:00 AM 542909 1335.00
10/10/2023 12:00:00 AM 542911 1132.35
10/11/2023 12:00:00 AM 542913 1442.50
10/11/2023 12:00:00 AM 542914 1650.00
10/12/2023 12:00:00 AM 542916 1913.85
10/16/2023 12:00:00 AM 542921 1926.06
10/19/2023 12:00:00 AM 542929 1585.00
10/19/2023 12:00:00 AM 542930 1632.15
10/23/2023 12:00:00 AM 542933 1255.80
10/25/2023 12:00:00 AM 542938 1660.00
10/26/2023 12:00:00 AM 542942 1852.00
10/31/2023 12:00:00 AM 542950 1140.00
11/2/2023 12:00:00 AM 542955 1030.76
11/6/2023 12:00:00 AM 542959 1764.00
11/6/2023 12:00:00 AM 542960 1974.00
11/8/2023 12:00:00 AM 542963 1007.70
11/8/2023 12:00:00 AM 542964 1508.12
11/9/2023 12:00:00 AM 542967 1254.00
11/15/2023 12:00:00 AM 542976 1112.00
11/16/2023 12:00:00 AM 542979 1052.14
11/22/2023 12:00:00 AM 542989 1438.25
11/27/2023 12:00:00 AM 542996 1461.60
11/28/2023 12:00:00 AM 542999 1630.00
12/4/2023 12:00:00 AM 543008 1620.00
12/4/2023 12:00:00 AM 543010 1875.00
12/6/2023 12:00:00 AM 543014 1450.60
12/6/2023 12:00:00 AM 543015 1209.00
12/17/2023 12:00:00 AM 543032 1015.80
12/18/2023 12:00:00 AM 543034 1924.25
12/24/2023 12:00:00 AM 543048 1930.00
12/24/2023 12:00:00 AM 543049 1122.80
12/25/2023 12:00:00 AM 543051 1936.00
12/27/2023 12:00:00 AM 543059 1174.75
12/28/2023 12:00:00 AM 543062 1925.50
1/3/2024 12:00:00 AM 543074 1139.10
1/3/2024 12:00:00 AM 543076 1407.50
1/8/2024 12:00:00 AM 543084 1902.10
1/9/2024 12:00:00 AM 543087 1762.70
1/10/2024 12:00:00 AM 543091 1122.00
1/11/2024 12:00:00 AM 543096 1255.60
1/14/2024 12:00:00 AM 543098 1408.00
1/15/2024 12:00:00 AM 543101 1733.06
1/17/2024 12:00:00 AM 543108 1500.70
1/18/2024 12:00:00 AM 543112 1014.00
1/21/2024 12:00:00 AM 543114 1809.75
1/22/2024 12:00:00 AM 543119 1353.60
1/24/2024 12:00:00 AM 543125 1196.00
1/25/2024 12:00:00 AM 543127 1980.00
1/25/2024 12:00:00 AM 543129 1261.00
1/28/2024 12:00:00 AM 543130 1075.00
1/28/2024 12:00:00 AM 543132 1902.00
2/4/2024 12:00:00 AM 543148 1575.00
2/5/2024 12:00:00 AM 543152 1402.00
2/5/2024 12:00:00 AM 543153 1500.00
2/6/2024 12:00:00 AM 543154 1966.81
2/6/2024 12:00:00 AM 543156 1030.00
2/7/2024 12:00:00 AM 543157 1170.30
2/7/2024 12:00:00 AM 543159 1286.80
2/11/2024 12:00:00 AM 543165 1754.50
2/11/2024 12:00:00 AM 543166 1692.00
2/13/2024 12:00:00 AM 543171 1887.00
2/14/2024 12:00:00 AM 543175 1309.50
2/14/2024 12:00:00 AM 543176 1564.00
2/15/2024 12:00:00 AM 543177 1090.50
2/18/2024 12:00:00 AM 543182 1665.00
2/19/2024 12:00:00 AM 543185 1727.50
2/20/2024 12:00:00 AM 543189 1838.00
2/21/2024 12:00:00 AM 543193 1445.50
2/26/2024 12:00:00 AM 543200 1873.50
2/27/2024 12:00:00 AM 543206 1057.00
2/27/2024 12:00:00 AM 543207 1374.60
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.