SQL commands - Scribblers Den

Before exploring the more complex elements of SQL, SQL, or Structured Query Language, is the industry standard for maintaining and modifying relational databases. Here are the top 10 SQL commands you should be familiar with by 2023.

Introduction to SQL commands

You may use a variety of commands to create, change, and retrieve data from a database. SQL is a vital ability for developers, database administrators, and data analysts to manage massive amounts of data for businesses and organizations.

Top 10 SQL Commands list:

SELECT SQL commands

By SELECT Command you can retrieve the data. One of the most used SQL procedures, it enables you to filter, sort, and aggregate data according to predetermined criteria.

Basic SELECT Statement

The basic SELECT statement retrieves all columns from a table:

SELECT * FROM table_name;

SELECT DISTINCT SQL commands

The SELECT DISTINCT command retrieves unique values from a column:

SELECT DISTINCT column_name FROM table_name;

SELECT TOP SQL commands

The SELECT TOP command retrieves a specified number of rows from a table:

SELECT TOP 10 * FROM table_name;

INSERT SQL commands

You can add a new row by INSERT Command. It’s essential for managing databases and keeping them up to date.

Basic INSERT Statement

The basic INSERT statement adds a new row to a table:

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);

INSERT INTO SELECT Statement

The INSERT INTO SELECT statement adds rows to a table from another table:

INSERT INTO table_name (column1, column2, column3) SELECT column1, column2, column3 FROM other_table_name;

UPDATE

You can modify existing data in a table by UPDATE Command. It allows you to change one or more columns in one or more rows.

UPDATE table_name SET column_name = new_value WHERE condition;

DELETE

You can remove the row or data by DELETE Command.

DELETE FROM table_name WHERE condition;

CREATE TABLE

You can create a new Table by CREATE TABLE Command.

CREATE TABLE table_name (column1 datatype, column2 datatype, column3 datatype);

ALTER TABLE Command

The ALTER TABLE command is used to modify an existing table in a database.

ADD Column

The ADD COLUMN command adds a new column to a table:

ALTER TABLE table_name ADD COLUMN column_name datatype;

DROP Column

The DROP COLUMN command removes a column from a table:

ALTER TABLE table_name DROP COLUMN column_name;

MODIFY Column

The MODIFY COLUMN command changes the data type of a column:

ALTER TABLE table_name MODIFY COLUMN column_name new_datatype;

DROP TABLE Command

The DROP TABLE command is used to remove a table from a database:

DROP TABLE table_name;

ORDER BY Command

The ORDER BY command is used to sort the result set of a query in ascending or descending order:

SELECT * FROM table_name ORDER BY column_name ASC|DESC;

GROUP BY Command

The GROUP BY command is used to group rows with similar values in a column and then perform aggregate functions on them:

SELECT column_name, aggregate_function(column_name) FROM table_name GROUP BY column_name;

Conclusion

Anyone who wants to work with data needs to know SQL. These 10 SQL commands list is a wonderful place for novices to start and lay the groundwork for more complex SQL capabilities. You can efficiently handle and manipulate data in any relational database by grasping and mastering these procedures.

Thank You