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 max(study_custom1) as 'Outside Institution', COUNT(study_custom1) as 'Number of Studies' from pacsdb.study where accession_no like '%OUT%' and study_custom1 is not null and created_time >= DATE_FORMAT( CURRENT_DATE - INTERVAL 1 MONTH, '%Y/%m/01' ) AND created_time < DATE_FORMAT( CURRENT_DATE, '%Y/%m/01' ) group by study_custom1 order by 'Number of Studies' DESC
site3 5 site2 8 site8 2 site4 1 site1 12
|Removing or extending the phpMyAdmin timeout period||5||34|
|Should I use a relational design for this?||3||51|
|Importing and exporting data Magento 1.x ?||4||30|
|how to get top 5 assets which having more tickets raised using sql||5||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!