Versions Compared

Old Version 1

changes.mady.by.user Jean-luc KRIKER

Saved on

compared with

New Version Current

changes.mady.by.user Jean-luc KRIKER

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Image Added





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