MSSQL Lab Test 1
/*1*/ SELECT CompanyName AS ‘ชื่อบริษัท’ FROM Customer_data ; /*2*/ SELECT CompanyName,Country FROM Customer_data WHERE Country=’Germany’; /*3*/ SELECT * FROM Customer_data WHERE Payment BETWEEN 1 AND 20 ORDER BY Country DESC; /*4*/ SELECT DISTINCT Country FROM Customer_data; /*5*/ SELECT CompanyName,ContectName,Region FROM Customer_data WHERE Region IS NOT NULL; /*6*/ SELECT CompanyName,ContectName,Contectitle FROM […]