SQL semaine1

De Memo
Aller à : navigation, rechercher
https://tableplus.com/
https://portal.azure.com/
CREATE TABLE francois_sales (
   id_product int,
   quantity int,
   price float
);
sp_columns grades
SELECT *
FROM grades AS A
LEFT JOIN ages AS B
ON CAST(A.Last_name AS CHAR) = CAST(B.Last_name AS CHAR);
SELECT *
INTO francois_grades
FROM grades
SELECT *
INTO francois_grades
FROM grades
WHERE 0=1