sql query example using db browser

Owned by Jean-luc KRIKER
Last updated: May 19, 2019
1 min read






basicSELECT * FROM master_price_2019_04
specific valueSELECT * FROM master_price_2019_04 WHERE ProductCategory = "Switches"

not-so-specific value  ( using wildcard )

https://www.w3schools.com/sql/sql_wildcards.asp

SELECT * FROM master_price_2019_04 WHERE ProductCategory = "Switches" AND LongDescription LIKE "%100G%"


output specific column

SELECT rawxxxxxxx  FROM tablexxxxx WHERE colunm_name_xxxxxx = "xxxxxxxxx 

SELECT ProductLine, ProductListPrice FROM master_price_2019_04 WHERE ProductCategory = "Switches" AND ProductType = "Base System" AND LongDescription LIKE "%100G%"