/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

3 votes488 views1 answer
How to get yesterday date in sql
SQL
0 vote366 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote386 views1 answer
Oracle grant create job
SQL
0 vote365 views1 answer
Sql date d'aujourd'hui
SQL
1 vote356 views2 answers
Sql server add time to date
SQL
0 vote357 views1 answer
Mysql query problems and solutions
SQL
2 votes368 views1 answer
How to delete columns in sql
SQL
1 vote338 views3 answers
Postgresql connect to database
SQL
0 vote455 views1 answer
Compare strings lexicographically in sql
SQL
2 votes388 views2 answers
Sql lag
SQL