/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 vote177 views1 answer
Find logged in users mysql
SQL
1 vote194 views1 answer
Oracle enable job
SQL
0 vote199 views1 answer
Disable database droping sql
SQL
1 vote195 views1 answer
Mysql column start with string
SQL
4 votes193 views2 answers
How to insert ip address in mysql using php
SQL
0 vote194 views1 answer
How to use lower case in mysql
SQL
1 vote235 views1 answer
Sql where max date
SQL
4 votes204 views3 answers
Rename table column postgresql
SQL
0 vote184 views2 answers
Pl sql auto increment
SQL
0 vote186 views1 answer
Laravel eloquent get generated sql
SQL