/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

11 votes348 views2 answers
Oracle source code
SQL
0 vote340 views2 answers
Temp Space
SQL
44 votes368 views6 answers
Rename command in sql
SQL
0 vote324 views1 answer
Sql pad left 0
SQL
0 vote305 views1 answer
Where in clause tsql
SQL
2 votes317 views1 answer
Postgresql left join distinct on
SQL
0 vote328 views1 answer
How to start my sql server on mac
SQL
0 vote407 views2 answers
Insert data into multiple tables mysql
SQL
3 votes315 views4 answers
Show databases in sql server
SQL
1 vote262 views1 answer
Prevent duplicate rows in postgres
SQL