SELECT sensor_alerts.*, sensor_instances.location
FROM sensor_instances
LEFT JOIN sensor_alerts ON sensor_instances.id = sensor_alerts.sensoridпервые 20 строкLIMIT and OFFSET или FETCH.
SELECT MONTH(purchase_date) AS mont, SUM(price) AS goods_sum
FROM goods
GROUP BY MONTH(purchase_date)SELECT YEAR(purchase_date) AS goods_year,
MONTH(purchase_date) AS goods_month,
SUM(price) AS goods_sum
FROM goods
GROUP BY YEAR(purchase_date), MONTH(purchase_date)
ORDER BY 1, 2SELECT * FROM (
SELECT contr, [time], SUM(val) OVER ( ORDER BY [time] ) AS sumcash
FROM something ) AS cash
WHERE sumcash <= max_cashcategory нет subcategory для id_subcat (110, 111).goods обрезан id_cat или нет разделения на подкатегории.SELECT goods.name_goods, subcategory.name_subcat, category.name_cat
FROM goods
LEFT OUTER JOIN category ON goods.id_cat = category.id
LEFT OUTER JOIN subcategory ON goods.id_cat = subcategory.id_subcat / 10select *
from the_table
where the_timestamp_column::date = date '2019-04-07'SELECT time FROM table ORDER BY id LIMIT 1 OFFSET 1WHERE ([date] IS NULL) OR ([date] = '20190101').WHERE (ISNULL([date], '20190101') = '20190101').
INSERT и DELETE в одном запросе не получится, нужна процедуре. В ней можно сделать всё, как у вас написано: удалить из таблицы, добавить отсутствующие.
SELECT buy.nomenclature_id,
SUM ( buy.summa )
- (SELECT ISNULL(SUM( sale.summa ),0)
FROM sale WHERE sale. nomenclature_id = buy. nomenclature_id)
FROM buy
GROUP BY buy.nomenclature_id
UNION
SELECT nomenclature_id, - SUM(summa)
FROM sale
GROUP BY nomenclature_id
HAVING (NOT (nomenclature_id IN (SELECT DISTINCT nomenclature_id FROM buy)))INSERT INTO galaxy (name, type, diametr FLOAT, mass, discovery_date, birth_date FLOAT,
astronomical_object )
VALUES (..., (SELECT MAX('id') FROM astronomical_object))Подзапрос возвращает более одной записиПросто
INSERT ... SELECT, без VALUES.необходимо в таблицу users_clans добавить такие данныеУ вас другие условия в запросах
INSERT INTO.