/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 vote123 views1 answer
Mysql best tutorial for beginners
SQL
-1 vote136 views1 answer
Su: Authentication failure mysql
SQL
16 votes145 views1 answer
Mysql smallint range
SQL
0 vote136 views1 answer
Sql select min row
SQL
2 votes131 views1 answer
Express api ith mysql data
SQL
1 vote136 views2 answers
Copy database mysql
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote127 views2 answers
How to search date in sql query
SQL
0 vote133 views1 answer
Min varias colunas spark sql
SQL
0 vote133 views1 answer
Renombrar tabla mysql
SQL