Here are 10 commonly used SQL function

SELECT Statement

SELECT column1, column2 FROM table WHERE condition;

COUNT() Function

SELECT COUNT(column) FROM table;

SUM() Function

SELECT SUM(column) FROM table;

AVG() Function

SELECT AVG(column) FROM table;

MIN() and MAX() Function

SELECT MIN(column) FROM table; SELECT MAX(column) FROM table;

GROUP BY Clause

SELECT column, COUNT(*) FROM table GROUP BY column;

DISTINCT Keyword

SELECT DISTINCT column FROM table;

CONCAT() Function

SELECT CONCAT(column1, ' ', column2) AS full_name FROM table;

DATE Function

SELECT CURRENT_DATE, CURRENT_TIME, DATE_FORMAT(date_column, '%Y-%m-%d') AS formatted_date FROM table;

LIKE Operator

SELECT column FROM table WHERE column LIKE 'pattern%';