/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 vote110 views1 answer
Sql get missing id
SQL
1 vote109 views1 answer
Oracle stop job
SQL
9 votes111 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote98 views1 answer
Postgresql function ROUND
SQL
0 vote106 views1 answer
Gcloud check sql
SQL
2 votes104 views2 answers
Oracle multiple insert
SQL
13 votes127 views3 answers
Sql select from multiple tables without join
SQL
0 vote115 views1 answer
Get schema of table sql
SQL
0 vote109 views2 answers
Get item by composite primary key mysql
SQL
0 vote107 views1 answer
To change the database owner in SQL server
SQL