Comments by johnathan indigo

johnathan indigo 10-Jul-21 13:53pm View

now im confused as to what i am joining?

johnathan indigo 10-Jul-21 13:52pm View

closer?

SELECT FundName, StrategyName, MarketName
FROM ProfitAndLoss
WHERE ValueDate IN( SELECT max( ValueDate) FROM ProfitAndLoss);
GROUP BY FundName, StrategyName, MarketName
ORDER BY MAX(ValueDate) DESC;

johnathan indigo 10-Jul-21 13:42pm View

on the right track?

SELECT FundName, StrategyName, MarketName
FROM ProfitAndLoss
WHERE ValueDate IN( SELECT max( ValueDate) FROM ProfitAndLoss);

johnathan indigo 10-Jul-21 13:03pm View

do you mind writing the query and explaining through it, I am lost..

johnathan indigo 10-Jul-21 12:49pm View

Deleted

I have given it a read, "it groups rows that have the same values into summary rows", but I'm struggling with the querying. Im i right to say that Valuedate is what has the same value and i want to group the market,strategy and fund rows?

johnathan indigo 10-Jul-21 12:23pm View

Deleted

I have given it a reed, "it groups rows that have the same values into summary rows", but I'm struggling with the querying. Im i right to say that Valuedate is what has the same value and i want to group the market,strategy and fund rows?

johnathan indigo 10-Jul-21 10:43am View

something like this?
SELECT FundName, StrategyName, MarketName
FROM profitAndLoss
GROUP BY mtdPnlUsd
SELECT MAX(MtdPnlUsd)

thoughts on this? im stuck on the JOIN as im not sure what ill used that for?

johnathan indigo 10-Jul-21 10:19am View

a better implementation, keeping the public interface the same?

Comments by johnathan indigo (Top 8 by date)