/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 vote119 views1 answer
Ubuntu stop mysql from starting on boot
SQL
3 votes115 views1 answer
Mysql set field unique
SQL
0 vote142 views1 answer
Edit shchima table in sql
SQL
0 vote117 views1 answer
Inserted row count tsql
SQL
18 votes125 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote120 views1 answer
Sql find record cannot cast date
SQL
0 vote136 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote129 views1 answer
Postgresql linux password
SQL
0 vote120 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes122 views1 answer
Sqlite indexes
SQL