27 Sep SQL Examples

We have made a list of live-running SQL query examples topic-wise. Let’s begin:

SQL CREATE and INSERT

• CREATE DATABASE Statement
• CREATE TABLE Statement
• Insert Records

SQL STATEMENTS

• SELECT Statement
• SELECT DISTINCT Statement
• SELECT TOP Statement
• SELECT INTO Statement
• UPDATE Statement
• ALTER TABLE Statement

SQL ORDER BY

• ORDER BY Statement

SQL Constraints

• SQL PRIMARY KEY Constraint
• SQL FOREIGN KEY Constraint
• SQL UNIQUE Constraint
• SQL CHECK Constraint
• SQL NOT NULL Constraint

SQL Operators

• SQL AND Operator
• SQL OR Operator
• SQL NOT Operator
• SQL LIKE Operator
• SQL IN Operator
• SQL BETWEEN and NOT BETWEEN Operator

SQL Built-in Functions

• SQL AVG() Method
• SQL SUM() Method
• SQL MIN() Method
• SQL MAX() Method
• SQL COUNT() Method

SQL Clauses

• SQL WHERE Clause

SQL DROP Statement

• Drop a Table

SQL Commands

• ASC Command
• DESC Command

SQL Advanced

• Backup a Database in SQL
• Views in SQL
• Create and Delete Indexes in SQL
• Aliases in SQL
• Stored Procedures in SQL