/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

6 votes352 views2 answers
Sql sequence
SQL
1 vote322 views1 answer
Simple project for database
SQL
0 vote366 views1 answer
Combine 2 columns search query mysql
SQL
0 vote330 views5 answers
Select concat alter table mysql
SQL
24 votes349 views6 answers
Replace mysql
SQL
2 votes327 views2 answers
Mysql limit
SQL
1 vote307 views2 answers
Difference between in and between in sql
SQL
0 vote312 views1 answer
H2 auto increment and unique
SQL
0 vote335 views1 answer
Sql ignore
SQL
0 vote364 views1 answer
Check if mysql db is used
SQL