-
Recent Posts
Recent Comments
- robert on Terminator Zombies
- robert on Stories I Tell To Entertain The Weak Minded
- nouveau maillot barca on Parsing XML With PHP SimpleXML
- PutThatThornBack on iCrap, Or Why I Hate Apple Products
- bear on A Public Service Announcement from F.O.O.D.
Archives
- December 2023
- October 2020
- September 2020
- January 2020
- March 2019
- November 2018
- August 2018
- July 2017
- June 2017
- December 2016
- May 2016
- April 2016
- July 2015
- June 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- May 2014
- April 2014
- September 2013
- December 2012
- November 2012
- August 2012
- June 2012
- May 2012
- March 2012
- February 2012
- November 2011
- October 2011
- September 2011
- July 2011
- June 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
Categories
- Airlines
- Art
- Complaints
- Computer Stuff
- crafts
- crochet
- Electronics
- Fun With Photoshop
- Government
- Gringo America
- jQuery
- Mac
- Movie Reviews
- My Opinion
- My WordPress Experiences
- MySQL
- Off Thoughts (Off as in Not Quite Right)
- PHP
- Poetry
- Remember When
- Reviews
- SQL
- Travel Agencies
- Useful Thoughts (as Opposed to Off Thoughts)
- writing
Meta
Monthly Archives: January 2015
MySQL Query Using Derived Temp Table And Left Join Against Self
An example (for a personal project) where I’m using a derived temp table (designated ‘x’) and a table joined against itself, used to find the max timestamp. Thanks, Martin! select tt.*, fkid, max(fldTimeStamp) as `maxTimeStamp`, (count(*)-1) as `calcCount` from tbl_todo … Continue reading