/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 vote435 views2 answers
Begin transaction sql
SQL
0 vote316 views1 answer
Check if a word appears at the end sql query
SQL
0 vote333 views1 answer
Use where instead of join
SQL
1 vote357 views2 answers
Postgresql remote connect
SQL
0 vote375 views1 answer
Netstat -tln mysql
SQL
2 votes349 views1 answer
How to find constraints on a table in oracle
SQL
0 vote351 views1 answer
Postgresql delete type
SQL
1 vote328 views1 answer
Stop mysql server mac
SQL
0 vote326 views1 answer
Create new table pl sql
SQL
0 vote382 views1 answer
Postgresql custom order by
SQL