/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 vote132 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote123 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote91 views1 answer
How to get last client id sql
SQL
0 vote138 views2 answers
Oracle create tablespace autoextend
SQL
0 vote168 views1 answer
Php insert null mysql
SQL
0 vote152 views1 answer
SQL Server date literal
SQL
3 votes173 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote149 views1 answer
Quit mysql
SQL
3 votes175 views2 answers
@sqlresultsetmapping
SQL
0 vote133 views1 answer
Sql how to display two atributes as one in sql
SQL