Blog Index For SQL

• 11-Aug-2020 Delete duplicates but keep first record
• 12-May-2020 Testing SQL with transactions
• 14-Apr-2020 Delete from a table where a matching value exists in another
• 07-Apr-2020 Remember != does not return nulls
• 20-Jan-2015 Populate a many-to-many relationship table with all possible combinations
• 16-Sep-2014 Conditional counting and summing in sql
• 02-Sep-2014 Using the HAVING clause to filter aggregate columns
• 12-Mar-2013 Copying Data Between Tables Using Insert Into Select or Select Into
• 11-Dec-2012 Using A Conditional Join To Flag Group Membership
• 17-Jan-2012 Inserting Multiple Rows With A Single SQL Statement
• 05-Jul-2011 Using Java To Rename Columns In A ColdFusion Query Object