Dofactory.com
SQL Editor

SQL Between Example

Tables and Columns 

Task:

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