Access
Есть таблица : Дата, Товар, Цена
Нужен запрос который вытащил цены на товар на определенную дату???
select Дата, товар, Цена from имя_таблицы where Дата=#yyyy-mm-dd#
select Дата, товар, Цена from имя_таблицы where Дата=#yyyy-mm-dd# and Товар='имя_товара'
select GoodId, Price, MAX(Date) as [LastChangeDate]
from MyTable
where date <= #MM/DD/YYYY#
group by GoodId, Price
SELECT GoodId, Price, MAX(Date) AS [LastChangeDate]
FROM MyTable
WHERE date <= #MM/DD/YYYY#
GROUP BY GoodId, Price
select t1.Price
FROM MyTable AS t1
INNER JOIN (
select GoodId, MAX(Date) as [LastChangeDate]
from MyTable
where date <= #MM/DD/YYYY#
group by GoodId, Price
) AS t1
WHERE t1.GoodId = t2.GoodId AND t1.Date = t2.LastChangeDate
SELECT SQ.GoodId, T.Price
FROM MyTable T
INNER JOIN (
SELECT GoodId, MAX(Date) AS [LastChangeDate]
FROM MyTable
WHERE date <= #MM/DD/YYYY#
GROUP BY GoodId
) SQ on (T.GoodId = SQ.GoodId
AND T.Date = SQ.LastChangeDate)
Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 0