/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

8 votes399 views4 answers
Postgresql server restart
SQL
2 votes401 views1 answer
How to check if a row is null in sql
SQL
1 vote350 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote358 views1 answer
Drop all data from tables
SQL
0 vote341 views1 answer
Postpresql relation not found
SQL
9 votes346 views4 answers
Add primary key to existing table sql
SQL
0 vote346 views1 answer
Linked server delete openquery
SQL
0 vote363 views1 answer
Mysql milliseconds
SQL
0 vote1.2K views1 answer
Mysql custom sort order
SQL
1 vote356 views1 answer
Oracle sql create view
SQL