This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
I have the following code, can somoene tell me what I did wrong? Thanks in advance. Select ProfitLoss, Name, DatePosition FROM interestprofit Where Security = '13508754' And TraderName = 'CAN' GROUP BY TraderName, Security Having DatePosition IN (Select DatePosition FROM interestprofit WHERE DatePosition = MAX(DatePosition))