/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

1 vote305 views1 answer
Primary key with prefix sql
SQL
3 votes322 views1 answer
What is having
SQL
11 votes291 views2 answers
Mysql disable safe mode
SQL
0 vote328 views1 answer
Delete from IN subquery
SQL
0 vote281 views1 answer
Systems sql
SQL
2 votes308 views1 answer
Alter table add column and foreign key mysql
SQL
12 votes290 views3 answers
Install sqlite driver ubuntu
SQL
0 vote270 views1 answer
Oracle job class
SQL
0 vote282 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote305 views1 answer
See the structure of a table mysql
SQL