Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT CustID, SUM(case when ItemCategory = 10 THEN PubProfit else 0 END) as ChemProfit, AVG(SUM(case when ItemCategory = 10 THEN PubProfit else 0 END)) as ChemAvg, SUM(CASE When InvoiceDate between '2015-1-1' and '2015-12-31' THEN PubProfit ELSE 0 END) as Profit15 From vCustomerInvoiceDetail Where InvoiceDate Between '2015-1-1' and '2015-12-31' Group by CustID Order by Profit15 Desc Limit 150
|Database Developement Theory. One table with 500 columns vs 1000 individual Tables.||5||67|
|Connect MySql database to wordpress site||3||20|
|Advice on encrpting some store produces on MS SQL sql||5||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!