/SQL/Sql parenthetical expression examples

Sql parenthetical expression examples

SELECT * FROM ihTags
WHERE (tagname LIKE *001 AND description="aa") OR tagname LIKE *002

Source: ge.com

Sql parenthetical expression examples

SELECT * FROM ihRawData WHERE tagname=Simulation00001 AND (Timestamp=>Tu AND Timestamp<=Wed OR Timestamp>=Fri AND time

Source: ge.com

Sql parenthetical expression examples

SELECT * FROM ihtags
WHERE (tagname LIKE '*001*' AND description LIKE '*sim*') OR
(tagname LIKE '*02*' AND (description LIKE '*sec*' OR description LIKE '*sim*'))

Source: ge.com

Similar codes

1 vote176 views2 answers
Insert sqlite
SQL
0 vote174 views1 answer
Sql server concat null
SQL
0 vote201 views1 answer
Site:av.ru "files"
SQL
8 votes167 views3 answers
Alter user root mysql
SQL
0 vote179 views1 answer
Codigo crear tablas sql server
SQL
0 vote179 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote206 views1 answer
Typical max-connect-errors mysql
SQL
0 vote180 views1 answer
For row in sql database python loop
SQL
32 votes193 views6 answers
Rename column mysql
SQL
1 vote185 views3 answers
Update from select sqlite
SQL