Sum of column in sql

sum of column in sql SELECT SUM(column_name) FROM table_name WHERE condition; sum sql SELECT SUM(column_name) FROM table_name WHERE condition; how to find averages on sql SELECT AVG(column_name) FROM table_name WHERE condition; select count sql SELECT COUNT(column_name) FROM table_name WHERE condition;

Sum of column in sql Read More

Sql server substring

sql server substring SELECT SUBSTRING(‘SQL Tutorial’, 1, 3) AS ExtractString; substring sql SELECT SUBSTRING(‘SQL Tutorial’, 4, (LENGTH(‘SQL Tutorial’)) AS LastCharactersString; //Result -> Tutorial grab part of a string sql SELECT     SUBSTRING(‘SQLTutorial.org’,         POSITION(‘.’ IN ‘SQLTutorial.org’));

Sql server substring Read More