/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 vote220 views4 answers
Best data type to represent money in mysql
SQL
4 votes178 views1 answer
Oracle error compilation line
SQL
0 vote308 views4 answers
Stored procedure sql
SQL
0 vote185 views1 answer
Oracle exchange subpartition
SQL
0 vote249 views1 answer
Sql database size
SQL
0 vote194 views1 answer
Full outer join in mariadb mysql
SQL
1 vote211 views1 answer
Mysql search like order by best match
SQL
2 votes183 views1 answer
Select * from table where name like
SQL
0 vote191 views1 answer
Mysql remove bad character from all fields
SQL
0 vote243 views1 answer
Fetching data from mysqldb
SQL