/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 vote216 views2 answers
Sql server add time to date
SQL
0 vote201 views1 answer
Phpmyadmin mysql conflict
SQL
2 votes211 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote201 views1 answer
Sql find table by name
SQL
0 vote185 views1 answer
Ms Sql set us timezone
SQL
2 votes224 views2 answers
Postgres timestamp to datetime
SQL
0 vote196 views2 answers
Postgresql create role
SQL
0 vote183 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
5 votes204 views1 answer
Oracle asynchronous update
SQL
1 vote204 views1 answer
Sql to mongodb query converter
SQL