/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 vote184 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote192 views1 answer
Mysql terminal list table
SQL
0 vote205 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote205 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
6 votes181 views2 answers
How to copy data in sql
SQL
1 vote249 views1 answer
Is sql fast
SQL
1 vote196 views1 answer
Convert epoch to date in sql server
SQL
18 votes215 views3 answers
Mysql add column default value
SQL
1 vote375 views2 answers
Sql unique rows
SQL
0 vote201 views1 answer
Oracle exchange partition
SQL