Пример использования:
SELECT product_id, SUM(amount) as total_sales
FROM sales
GROUP BY product_id
HAVING SUM(amount) > 1000;
Please open Telegram to view this post
VIEW IN TELEGRAM
👨💻4🐳2🔥1
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥5🐳1👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳4🔥2👨💻1
Различия между WHERE и HAVING:
Пример для сравнения:
-- Использование WHERE для фильтрации строк
SELECT product_id, amount
FROM sales
WHERE amount > 100;
-- Использование HAVING для фильтрации агрегированных данных
SELECT product_id, COUNT(*) as sale_count
FROM sales
GROUP BY product_id
HAVING COUNT(*) > 10;
Please open Telegram to view this post
VIEW IN TELEGRAM
👨💻3🔥2🐳1
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳4🔥1👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
YouTube
Postgres vs Mongo / Олег Бартунов (Postgres Professional)
Приглашаем на конференцию HighLoad++ 2025, которая пройдет 6 и 7 ноября в Москве!
Программа, подробности и билеты по ссылке: https://highload.ru/moscow/2025
________
РИТ++ 2017, Backend Conf
Тезисы:
http://backendconf.ru/2017/abstracts/2781.html
Я хочу…
Программа, подробности и билеты по ссылке: https://highload.ru/moscow/2025
________
РИТ++ 2017, Backend Conf
Тезисы:
http://backendconf.ru/2017/abstracts/2781.html
Я хочу…
🐳3🔥2👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳4🔥2👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳3🔥2👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥3🐳2👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥3🐳2👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳4🔥1👨💻1
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥3🐳2👨💻1
const num = 10
console.log( Number.isInteger(num) )
// true
const num = 10.3
if (num % 1 === 0) {
console.log ('Число целое')
} else {
console.log ('Число не целое')
}
// Число не целое
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳3👨💻2🔥1