/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 vote150 views1 answer
Select from 3 tables one is empty
SQL
3 votes156 views1 answer
Locate sql server
SQL
0 vote150 views1 answer
How should I pass a table name into a stored proc?
SQL
1 vote153 views1 answer
Mysql select utc time in eastern time
SQL
0 vote175 views1 answer
Check if mysql db is used
SQL
0 vote186 views1 answer
Get initials name in sql
SQL
0 vote152 views1 answer
Postgresql default value boolean
SQL
-1 vote166 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
3 votes168 views2 answers
How to delete git repo locally
SQL
0 vote153 views1 answer
Recursive query herarchical data sql server
SQL