Tag Archives: query

Count occurrences both greater than, less than, or equal in MySQL

Leave a comment

  SELECT COUNT(recycled) AS “Total”, SUM(CASE WHEN recycled = 1 THEN 1 ELSE 0 END) AS “New”, SUM(CASE WHEN recycled > 1 THEN 1 ELSE 0 END) AS “Recycled” FROM (a SELECT phone_number, count(*) AS recycled, sale_date FROM ( SELECT DISTINCT * FROM ( SELECT customers.phone_number, customers.sale_date FROM customers INNER JOIN ( SELECT customers.phone_number FROM customers WHERE sale_date BETWEEN ‘2014-05-23’ AND ‘2014-05-30’) list on customers.phone_number = list.phone_number ORDER BY phone_number DESC, sale_date DESC ) AS multiple_sales ) AS sale_dates_analysis GROUP

Read more Software Tips, Work

Work links: slider selects and fuzzy queries

Leave a comment

I’m working on a new project, here are some links that have been helpful to me… Overview of slider techniques: Javascript/Ajax Techniques for Sliders – Noupe http://www.noupe.com/javascript/30-javascriptajax-techniques-for-sliders-scrollers-and-scrollbars.htmlIn this article we’d like to present a list of hand-picked Slider techniques you can use to achieve some special visual effects in your designs… Specific slider examples: jQuery UI Slider from a Select Element – now with ARIA Support http://www.filamentgroup.com/lab/update_jquery_ui_slider_from_a_select_element_now_with_aria_support// selectToUISlider plugin uses progressive enhancement to scrape the data from a select element

Read more Work