/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 votes114 views5 answers
Alter table primary key postgresql
SQL
6 votes162 views1 answer
Oracle rank
SQL
19 votes156 views5 answers
Change column name mysql command line
SQL
0 vote164 views1 answer
Grant owner postgresql
SQL
0 vote158 views1 answer
Mysql_union
SQL
16 votes176 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote168 views2 answers
Mysql error 1215
SQL
2 votes140 views1 answer
Codeigniter print last sql query
SQL
0 vote164 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
3 votes149 views1 answer
Mysql UPDate with enner join
SQL