basic sql commands

Hello,

Please find some of basic sql query,

• Select

SELECT column1, column2 FROM table_name WHERE condition;

• Insert

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

• Update

UPDATE table_name SET column1 = value1 WHERE condition;

• Delete

DELETE FROM table_name WHERE condition;

• Create table

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

• Alter Table

ALTER TABLE table_name
ADD column_name datatype;

ALTER TABLE table_name
MODIFY column_name datatype;

• Drop table

DROP TABLE table_name;

• Where Clause

SELECT column1, column2 FROM table_name WHERE condition;

Please refer this link for basic of SQL

https://www.c-sharpcorner.com/Resources/4395/sql-server-tutorial-for-beginners.aspx

https://www.sqlservertutorial.net/

Do you know which of the following subsets of SQL you want to know about?

• Data Query Language (DQL)
• Data Definition Language (DDL)
• Data Control Language (DCL)
• Data Manipulation Language (DML)

What do you want to learn? Detail it please.