Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »






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%"





























  • No labels