Functions in MySQL are easy

preview_player
Показать описание
#MySQL #SQL #course

More functions can be found here:

SELECT COUNT(amount) as count
FROM transactions;

SELECT MAX(amount) AS maximum
FROM transactions;

SELECT MIN(amount) AS minimum
FROM transactions;

SELECT AVG(amount) AS average
FROM transactions;

SELECT SUM(amount) AS sum
FROM transactions;

SELECT CONCAT(first_name, “ ”, last_name) AS full_name
FROM employees;
Рекомендации по теме
Комментарии
Автор

More functions can be found here:

SELECT COUNT(amount) as count
FROM transactions;

SELECT MAX(amount) AS maximum
FROM transactions;

SELECT MIN(amount) AS minimum
FROM transactions;

SELECT AVG(amount) AS average
FROM transactions;

SELECT SUM(amount) AS sum
FROM transactions;

SELECT CONCAT(first_name, “ ”, last_name) AS full_name
FROM employees;

BroCodez
Автор

You are real deal BOSS! Take love from Bangladesh ❤❤

niloyahmed
Автор

NGL i'm learning SSMS and this is very helpful i just change somethings here and there and boom got it

EvoRudzi
Автор

these videos are still helpful to this day😊

basidabdi
Автор

Hi please make some OpenGL tutorials for C++ in the C++ playlist

shapvoid
Автор

Amazing videos broo jewel of a content✨🙌🎉😍

srinidhibandi
Автор

Could you pls pls do a full course on SQL . 🥹🙏

vikrant
Автор

hi bro code how would i combine a exam grade (70% of total grade) and a quiz grade (30% of grade) to form a final grade in a function? Love the vids

ncwhit