/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 vote355 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
2 votes378 views1 answer
Mysql trigger after update
SQL
0 vote364 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote339 views1 answer
Safe mysql
SQL
23 votes349 views1 answer
How remove column in mysql
SQL
0 vote344 views1 answer
Sql cheetsheet
SQL
0 vote363 views1 answer
Template MySQL Zabbix agent
SQL
18 votes348 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote348 views1 answer
Sql server query database space available
SQL
0 vote332 views1 answer
Sql remove last x char
SQL