Languages
[Edit]
EN

SQL - fundamentals (Cross technology)

0 points
Created by:
Lani-Skinner
438

Below is a list of basic SQL concepts with references to various database management systems.

 

ProblemCrossMySQLMS SQL ServerPostgreSQLSQLite
Aliases---link-
Alter Tablelinklinklinklink-
AND, OR, NOT operatorslinklinklinklink-
BETWEEN clauselinklinklinklink-
CASE statementlinklinklinklink-
Commentslinklinklinklink-
Create databaselinklinklinklink-
Create tablelinklinklinklink-
Create viewlinklinklinklink-
Delete querylinklinklinklink-
Drop databaselinklinklinklink-
Drop tablelinklink-link-
Drop viewlinklink-link-
Full Outer Joinlinklinklinklink-
GROUP BY statementlinklinklinklink-
Inner Joinlinklinklink--
INSERT INTO statementlinklinklinklink-
JOIN list + SQL Querylinklinklinklink-
Left Joinlinklinklink--
LIKE operatorlinklinklinklink-
LIMIT clauselinklinklinklink-
ORDER BY clauselinklinklinklink-
Right Joinlinklinklink--
SELECT DISTINCT statementlinklinklinklink-
Select querylinklinklink--
UPDATE statementlinklinklinklink-
WHERE clauselinklinklinklink-

 

Cross technology - common problems

Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join