入力
入力テーブルは、AntiSelect例1にあるようにantiselect_testです。
SQL呼び出し
SELECT * FROM Antiselect (
ON antiselect_test
USING
Exclude ('id', '[2:3]', 'custname:prodcat')
) AS dt ORDER BY 1, 4;
出力
| sno | qty | sales | disct | dmode |
|---|---|---|---|---|
| 1 | 6 | 2.61540000000000E 002 | 0.04 | Regular Air |
| 49 | 49 | 1.01230000000000E 004 | 0.07 | Delivery Truck |
| 50 | 27 | 2.44570000000000E 002 | 0.01 | Regular Air |
| 80 | 30 | 4.96576000000000E 003 | 0.08 | Regular Air |
| 85 | 19 | 3.94270000000000E 002 | 0.08 | Regular Air |
| 86 | 21 | 1.46690000000000E 002 | 0.05 | Regular Air |
| 97 | 12 | 9.35400000000000E 001 | 0.03 | Regular Air |