/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

2 votes198 views1 answer
How to find constraints on a table in oracle
SQL
0 vote192 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
4 votes194 views1 answer
Mysql insert from local csv
SQL
0 vote276 views1 answer
Radius search with point data in mysql
SQL
17 votes200 views4 answers
Sort by mysql
SQL
1 vote193 views1 answer
Mysql check string don't have number
SQL
0 vote210 views1 answer
Mysql select smaller of two values
SQL
0 vote206 views1 answer
Sql insert tuple
SQL
0 vote204 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote208 views1 answer
Select all columns except one sql
SQL