Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.21 » View Incident Report |
Minor |
Reported By: Sanford Aranoff Reported On: 6/10/2005 For: Version 4.21 Build 3 |
select extract (year from s.TradeDate) as Year, sum(s.Profit) as [Real P&L], sum(s.ImgProfit) as [Unreal P&L], Max(s.profit), Min(s.Profit), Count(s.Profit), Avg(s.Profit), Round(StdDev(s.Profit)) from StockTraded s group by year having ([Real P&L] > 0.01 or [Real P&L] < -0.01) order by year desc
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |