/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 vote250 views2 answers
Wordpress change url after migration mysql query
SQL
13 votes224 views6 answers
Current date sql
SQL
1 vote207 views2 answers
Mysql SELECT
SQL
6 votes224 views5 answers
Alter table oracle
SQL
10 votes214 views3 answers
Sql limit results
SQL
0 vote241 views1 answer
Get primary key of table
SQL
25 votes243 views3 answers
How to use a database to see tables mysql
SQL
0 vote215 views1 answer
Wordpress sql change site url
SQL
7 votes229 views2 answers
Oracle foreign key reference table
SQL
0 vote258 views1 answer
Postgresql custom order by
SQL