1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
USE plato;
SELECT
cs_ext_list_price == cs_ext_tax,
cs_ext_list_price != cs_ext_tax,
cs_ext_list_price < cs_ext_tax,
cs_ext_list_price <= cs_ext_tax,
cs_ext_list_price > cs_ext_tax,
cs_ext_list_price >= cs_ext_tax,
cs_ext_tax == decimal("26.91", 7, 2),
cs_ext_tax != decimal("26.91", 7, 2),
cs_ext_tax < decimal("26.91", 7, 2),
cs_ext_tax <= decimal("26.91", 7, 2),
cs_ext_tax > decimal("26.91", 7, 2),
cs_ext_tax >= decimal("26.91", 7, 2),
decimal("26.91", 7, 2) == cs_ext_tax,
decimal("26.91", 7, 2) != cs_ext_tax,
decimal("26.91", 7, 2) < cs_ext_tax,
decimal("26.91", 7, 2) <= cs_ext_tax,
decimal("26.91", 7, 2) > cs_ext_tax,
decimal("26.91", 7, 2) >= cs_ext_tax,
FROM Input;
|