/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

3 votes261 views1 answer
Stpop start psql server
SQL
1 vote201 views1 answer
How to run sql script
SQL
0 vote302 views1 answer
Python dictionary to sql update
SQL
0 vote248 views1 answer
Print orcale
SQL
0 vote242 views1 answer
Difference between cross apply and inner join
SQL
0 vote293 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote265 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote255 views1 answer
Arithmetic expression in sql
SQL
0 vote246 views1 answer
Sql drop default
SQL
1 vote248 views1 answer
Mysql sort by date column
SQL