-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathcondition04.sql
More file actions
36 lines (34 loc) · 835 Bytes
/
condition04.sql
File metadata and controls
36 lines (34 loc) · 835 Bytes
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
26
27
28
29
30
31
32
33
34
select *
from t
where
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
( type = '2' ) or ( type = '3' )
) and ( t.cde < 20 )
) and ( t.se = 'xxx' )
) and ( t.id = '000000000002' )
) and ( ( t.attr_1 is null ) or ( t.attr_1 = '*' ) )
) and ( ( t.attr_2 is null ) or ( t.attr_2 = '*' ) )
) and ( ( t.attr_3 is null ) or ( t.attr_3 = '*' ) )
) and ( ( t.attr_4 is null ) or ( t.attr_4 = '*' ) )
) and ( ( t.attr_5 is null ) or ( t.attr_5 = '*' ) )
) and ( ( t.itype is null ) or ( t.itype = '*' ) )
) and ( ( t.inbr is null ) or ( t.inbr = '*' ) )
) and ( ( t.stat = '01' ) or ( t.stat = '*' ) )
) and ( ( t.orgn is null ) or ( t.orgn = '*' ) )
) and ( t.mbr = '0000000000001' )
) and ( t.nbr is null )
)