Gordon Linoff questions

Gordon Linoff answers

• Using a current row value into a subquery
• Select unique count of rows referenced
• How to sum total amount for every month in a year?
• SQLServer update statement chokes on null value, even with isNull()
• Count all subordinates who directly or indirectly reports to managers
• MySQL Insert if Condition
• Oracle: Convert string to double
• Is there a simpler way to find MODE(S) of some values in MySQL
• Writing a Stored Procedure If/Else to create error message
• Guideline for SQL Server APPLY AND JOIN Keyword