/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

2 votes275 views1 answer
How to create sql database
SQL
0 vote257 views1 answer
Disableforiegn key check
SQL
0 vote276 views1 answer
Pgsql is not permitted to log in
SQL
1 vote298 views1 answer
Connect to mysql database ubuntu
SQL
2 votes266 views1 answer
How to add where command in update comand with joins
SQL
1 vote264 views1 answer
Oracle create program if no exists
SQL
1 vote262 views1 answer
Sql server reseed single table
SQL
0 vote296 views1 answer
Mysql a from on this page has
SQL
1 vote259 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes285 views1 answer
Mariadb json select
SQL