SELECT EM.MARKET_SHORT, tp.trading_place_short, to_char(EH.C$DATE,'dd.mm.yyyy') "C$DATE", COUNT(*)
FROM KIP.EXQ_HISTORY eh,
KIP.EXQ_INSTRUMENTS ei,
KIP.EXQ_TRAIDING_PLACES tp,
KIP.EXQ_MARKETS em
WHERE ei.INSTRUMENT_ID = eh.C$INSTRUMENT and
ei.trading_place_id = tp.traiding_place_id and
tp.MARKET_PLACE_ID = em.MARKET_PLACE_ID
and trunc(eh.C$DATE)=to_date(:DATE_OF_QUATATION,'DD.MM.YY')--укажите необходимую дату
group by em.MARKET_SHORT,eh.c$date, tp.trading_place_short
order by market_short, tp.trading_place_short;
--and em.MARKET_SHORT = 'MICEX'
--and ei.instrument_short = 'LKOH' |