/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

10 votes253 views1 answer
All_dependencies
SQL
1 vote261 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote261 views3 answers
Psql fatal database does not exist
SQL
4 votes253 views3 answers
Create database in mySQL
SQL
1 vote266 views1 answer
Woocommerce mysql price table
SQL
11 votes260 views2 answers
Mysql disable safe mode
SQL
7 votes261 views1 answer
Set sequence value oracle
SQL
-1 vote294 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote282 views1 answer
Show tables in cassandra cql
SQL
0 vote283 views1 answer
Apt install sql server
SQL