/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 vote318 views1 answer
Mysql select all where count more than"
SQL
92 votes606 views6 answers
Substring
SQL
2 votes332 views1 answer
How to insert string variable into sqlite database
SQL
0 vote327 views1 answer
Equi joins in oracle
SQL
0 vote317 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote367 views1 answer
Pl sql disable trigger
SQL
0 vote341 views1 answer
Postgresql using reserved word as column name
SQL
2 votes374 views2 answers
Oracle create table if not exists
SQL
0 vote340 views1 answer
Automated psql csv export script on windows
SQL
1 vote338 views2 answers
Insert sqlite
SQL