/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 vote234 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote160 views1 answer
Create function in microsoft sql server
SQL
0 vote139 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
7 votes153 views2 answers
N highest salary in sql
SQL
0 vote156 views1 answer
Postgresql inheritance
SQL
0 vote151 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote140 views1 answer
Selects all the columns from the sailors table
SQL
0 vote176 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote137 views1 answer
C# add a textbox in mysql select
SQL
0 vote178 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL