Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Selecting
Columns
*
X,Y,W
DISTINCT: تعطي القيم الفريدة فقط
COUNT(): تعطي مجموع القيم فقط
AVG()
SUM()
MIN() / MAX()
AS: لعمل عمود وهمي
Filtering
Rows
WHERE title = 'Metropolis';
WHERE budget > 10000;
WHERE year > 1994
AND
< 2000;
WHERE year > 1994
OR
< 2000;
WHERE
(year > 1994 AND < 2000) (Age > 60 OR < 20);
WHERE age IN (2, 4, 6, 8, 10);
WHERE birthdate IS NULL / NOT NULL;
WHERE name LIKE / NOT LIKE 'Data';
Data%
Sorting& Grouping
ORDER BY name;
ORDER BY name DESC;
SELECT
FROM
WHERE
ORDER BY