/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

18 votes196 views2 answers
How to get all the tables displayed in oracle
SQL
3 votes241 views2 answers
Get current year sql
SQL
16 votes256 views3 answers
Update table from another table
SQL
5 votes256 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes228 views1 answer
How to check grants on a package in oracle
SQL
0 vote229 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
7 votes211 views2 answers
Create mysql user
SQL
0 vote216 views1 answer
Full syntax inner join
SQL
5 votes243 views4 answers
Rollback to in sql
SQL
0 vote259 views1 answer
SQL joins in python
SQL