CASE… WHEN… ELSE… END
November 12, 2022
Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
Advanced SQLSQL TutorialsWhat is an aggregate function?
October 19, 2022
An aggregate function where the values are grouped together to form a single response. The more common SQL aggregate functions are SUM, COUNT, AVG, MIN and MAX.
Advanced SQLSQL TutorialsSQL tutorials for beginnersTransact-SQL