/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 vote122 views1 answer
Is not null postgresql
SQL
0 vote131 views1 answer
What is metadata in sql
SQL
-2 votes125 views1 answer
How to open database
SQL
0 vote128 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote130 views1 answer
Sql select contem uma palavra
SQL
0 vote136 views1 answer
Mysql zerofill
SQL
10 votes135 views2 answers
Mysql alter add foreign key
SQL
5 votes125 views1 answer
Sqlite alter table add column
SQL
0 vote127 views1 answer
Mysql return column names when table is empty
SQL
8 votes151 views1 answer
Mysql restore database
SQL