/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 vote131 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote137 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote152 views1 answer
Postgresql port 5432 not open
SQL
3 votes92 views1 answer
Ubuntu install postgresql 12
SQL
0 vote143 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote131 views1 answer
Where not in array sql
SQL
5 votes152 views1 answer
Oracle columns in all_tables
SQL
0 vote137 views1 answer
Mysql order by rand limit 1 really slow
SQL
5 votes136 views1 answer
Purge undo tablespace oracle 11g
SQL
-1 vote142 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL