/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

11 votes285 views2 answers
Having keyword sql
SQL
0 vote330 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote315 views1 answer
Create database like
SQL
0 vote325 views1 answer
Running percentage of total postgres
SQL
9 votes312 views2 answers
Sql limit to 5 results
SQL
7 votes299 views3 answers
Sql get last inserted row
SQL
2 votes368 views3 answers
Sql delete duplicate
SQL
0 vote318 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
6 votes344 views2 answers
Mysql convert timestamp to date
SQL
17 votes352 views3 answers
Postgresql list users
SQL