/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

0 vote144 views1 answer
Get time component of datetime sql
SQL
0 vote142 views1 answer
R write csv without index
SQL
2 votes161 views2 answers
Mysql does sentence contain word
SQL
2 votes165 views3 answers
Application.properties spring boot mysql
SQL
2 votes146 views2 answers
Insert all in sql
SQL
1 vote140 views3 answers
Mysql Server Start
SQL
0 vote135 views1 answer
Sql inserted
SQL
1 vote151 views2 answers
Restart identity cascade
SQL
0 vote134 views1 answer
Sql get month from date
SQL
11 votes134 views1 answer
Mysql order by two columns priority
SQL