/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 vote148 views1 answer
Mod in sql
SQL
0 vote147 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote255 views1 answer
Sql injection
SQL
0 vote151 views1 answer
New rails app with mysql
SQL
9 votes148 views1 answer
Oracle get table schema
SQL
0 vote159 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote158 views2 answers
Jsonb
SQL
0 vote156 views1 answer
Postgres regex word boundary
SQL
1 vote155 views1 answer
How to group by month using sql server
SQL
0 vote142 views6 answers
Unique key in sql
SQL