Scribd
Upload
2 views7 pages

SQL Command Overview Guide

Structured Query Language (SQL) is a language used to manage data in relational database management systems. It includes commands like CREATE TABLE to make new tables, INSERT to add data, SELECT to retrieve data, DISTINCT to eliminate duplicate values, ORDER BY to sort results, WHERE to filter results, and functions like SUM, AVG, MAX, MIN, and COUNT to perform calculations on data groups. Other commands are UPDATE to modify data, ALTER TABLE to modify table structures, and GROUP BY to group and organize aggregated data.

Uploaded by

aruna
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views7 pages

SQL Command Overview Guide

Structured Query Language (SQL) is a language used to manage data in relational database management systems. It includes commands like CREATE TABLE to make new tables, INSERT to add data, SELECT to retrieve data, DISTINCT to eliminate duplicate values, ORDER BY to sort results, WHERE to filter results, and functions like SUM, AVG, MAX, MIN, and COUNT to perform calculations on data groups. Other commands are UPDATE to modify data, ALTER TABLE to modify table structures, and GROUP BY to group and organize aggregated data.

Uploaded by

aruna
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

STRUCTURED QUERY LANGUAGE

 CREATE TABLE COMMAND:

 INSERT COMMAND:
 SELECT COMMAND:
 DISTINCT COMMAND:

 ALL COMMAND:

 ORDER BY COMMAND
 WHERE COMMAND:
SUM FUNCTION:

AVG FUNCTION:

MAX FUNCTION:

MIN FUNCTION:
COUNT FUNCTION:

GROUP BY COMMAND:

UPDATE COMMAND:
ALTER TABLE COMMAND:

You might also like