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;
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;
You can remove the row or data by DELETE Command.
DELETE FROM table_name WHERE condition;
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.
The ADD COLUMN command adds a new column to a table:
ALTER TABLE table_name ADD COLUMN column_name datatype;
The DROP COLUMN command removes a column from a table:
ALTER TABLE table_name DROP COLUMN column_name;
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;
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.
Follow Us on