/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

1 vote276 views1 answer
Limit offset order by mysql
SQL
13 votes304 views1 answer
Select count of distinct values sql
SQL
0 vote296 views1 answer
Enable full text search mysql
SQL
4 votes283 views1 answer
Psql get sequences
SQL
0 vote341 views1 answer
Wordpress make wp user in db
SQL
1 vote290 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote288 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote295 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
2 votes298 views4 answers
Mysql select into new table
SQL
2 votes289 views1 answer
Brew start postgres manual
SQL