SQL Commands
In this section, we discuss the following SQL commands, which are frequently used in SQL queries. By the end of this section, you will learn the basics of retrieving data from the database using SQL.
- SQL SELECT Statement
- SQL DISTINCT
- SQL WHERE
- SQL AND OR
- SQL IN
- SQL BETWEEN
- SQL Wildcard
- SQL LIKE
- SQL ORDER BY
- SQL Aggregate Functions
- SQL Average
- SQL COUNT
- SQL MAX
- SQL MIN
- SQL SUM
- SQL GROUP BY
- SQL HAVING
- SQL ALIAS
- SQL INNER JOIN
- SQL OUTER JOIN
- SQL LEFT OUTER JOIN
- SQL CROSS JOIN
- SQL SELECT UNIQUE
- SQL ROUND
- SQL CAST
- SQL CONVERT
- SQL CONCATENATE
- SQL SUBSTRING
- SQL TRIM
- SQL LENGTH
- SQL REPLACE
- SQL DATEADD
- SQL DATEDIFF
- SQL DATEPART
- SQL GETDATE
- SQL SYSDATE