Przeznaczenie discoverer – logistyka
SELECT t.conversion_date,
conversion_rate "Jest",
t.inverse_conversion_rate,
1 / t.inverse_conversion_rate "Powinno być"
FROM apps.gl_daily_rates_v t
WHERE user_conversion_type = 'NBP'
AND from_currency = 'PLN'
AND to_currency = 'EUR'
AND t.conversion_rate NOT IN
(SELECT 1 / t1.inverse_conversion_rate
FROM apps.gl_daily_rates_v t1
WHERE user_conversion_type = 'NBP'
AND from_currency = 'PLN'
AND to_currency = 'EUR') |
select t.conversion_date,
conversion_rate "Jest",
t.inverse_conversion_rate,
1 / t.inverse_conversion_rate "Powinno być"
from apps.gl_daily_rates_v t
where user_conversion_type = 'NBP'
and from_currency = 'PLN'
and to_currency = 'EUR'
and t.conversion_rate not in
(select 1 / t1.inverse_conversion_rate
from apps.gl_daily_rates_v t1
where user_conversion_type = 'NBP'
and from_currency = 'PLN'
and to_currency = 'EUR')
Ten wpis został opublikowany w kategorii
Discoverer i oznaczony tagami
kolory,
wygląd. Dodaj zakładkę do
bezpośredniego odnośnika.