/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 vote206 views1 answer
Mysql group rows with same value
SQL
3 votes219 views1 answer
Sql server version query
SQL
0 vote228 views1 answer
Mysql last friday of current month
SQL
0 vote205 views1 answer
Events not working db
SQL
0 vote253 views1 answer
Min varias colunas spark sql
SQL
1 vote228 views1 answer
Round function in sql oracle
SQL
0 vote211 views1 answer
Add column not null with default value postgres
SQL
0 vote251 views1 answer
Add user mysql wordpress
SQL
1 vote218 views1 answer
Sql server get users
SQL
0 vote218 views1 answer
Get number of rows in every table mysql
SQL