Aaron Parecki

#sql

• 

  Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?

  

  Portland, Oregon, USA • 57°F

  6 likes 3 reposts 12 replies 1 mention

  Fri, Sep 16, 2022 8:51am -07:00 #sql
• Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog (phiresky.github.io)

  Sun, May 2, 2021 4:37pm -07:00 #sqlite #static #web #sql #database
• Run SQL on JSON files -- without any data loads (citusdata.com)

  Sun, Aug 24, 2014 8:59am -07:00 #database #json #sql
• Window Functions (www.postgresql.org)

  Sat, Aug 25, 2012 9:56am -07:00 #database #documentation #postgres #sql #tutorial
• (My)SQL mistakes. Do you use GROUP BY correctly? (www.dbasquare.com)

  Wed, May 16, 2012 8:09am -07:00 #db #mysql #sql
• WhySQL? (blog.evernote.com)

  Thu, Feb 23, 2012 8:36am -08:00 #evernote #hardware #sql #technology

• Sorting a query in MySQL ignoring the word "The"

  When you have a database of books or movies, some of the titles begin with "The." If you do a regular ORDER BY on the table, all the titles that start with "the" get clumped together. One option is running an unsorted query and sorting in PHP, but it would be better to sort at the database level. Here is a query I came up with to do that, using an IF function in MySQL!

  continue reading...

  Sat, Apr 19, 2008 9:50pm -07:00 #code #database #MySQL #sorting #SQL