Brian DeMilia questions

Brian DeMilia answers

• MY SQL Query for thread messaging inbox and sent
• PHP MySQL Highscore table
• SQL combined SELECT statement
• SQL COUNT() function and LEFT OUTER JOIN
• LEFT JOIN returns same result as INNER JOIN
• SQL Merge two rows with same ID but different column values (Oracle)
• subquery uses ungrouped column "i.date_time" from outer query
• How to get the first and the last record per group in SQL Server 2008?
• SQL Server: compare datetime day with GETDATE()
• Self join many-to-many relationship