Viewing 8 posts - 1 through 8 (of 8 total)
OOPs did not see that ... Corrected code Thank you.. Please let me know
SELECT User.TraderID, User.NameofTrader, User.RegionofTrader, Trade.Ticker, Trade.TraderDate, Count(*) AS NumTrades
FROM [User] INNER JOIN Trade...
March 22, 2018 at 5:38 pm
Select U.TraderID, U.NameofTrader, U.RegionofTrader, Count(*) NumTrades
from Trading T
left join on user U U.TraderID = T.TraderID
Group by U.TraderID, U.NameofTrader, U.RegionofTrader
order by count(*) desc
March 21, 2018 at 7:35 pm
remove duplicate consecutive rows using the key PI, m and TT.
Create transactions when PI, M, TT changes based on the order of date. When TT changes a new...
January 2, 2018 at 8:59 am
Obtained results