/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 vote114 views1 answer
Jenkins SQLCMD run
SQL
1 vote119 views1 answer
Check if mysql is installed
SQL
0 vote102 views1 answer
Alter table fulltext
SQL
1 vote114 views1 answer
Sql select where id not exists in another table
SQL
0 vote107 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote124 views1 answer
Add sequence postgres
SQL
6 votes104 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote107 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote124 views1 answer
Mysql coonect sample code
SQL
0 vote117 views1 answer
Exit psql
SQL