Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
//MONTHLY SELECT yr_mo,model_name,Previous_month,Current_month,( (Current_month - Previous_month) / Previous_month) as monthly_growth from ( SELECT yr_mo,model_name,fla_inservice_totals as Current_month, (SELECT fla_inservice_totals FROM Table e2 WHERE e2.model_name = e1.model_name AND e2.yr_mo < e1.yr_mo AND yr_mo = '2014-06' ORDER BY yr_mo DESC LIMIT 1) Previous_month FROM Table e1 WHERE yr_mo = '2014-07' )t1;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!