Fahmi questions

Fahmi answers

• How to use count if in mysql
• How to display unique records in a table using MySQL
• How do I select rows where today's date falls in between start and end date inclusive
• Selecting a column from table based on value stored in table
• Rows with multiple corresponding values in the same table
• Select timestamp for one date and for a period time on the same field in one query
• Return null if value does not exist
• First 5 rows summed per ref per type, all others equal 1, grouped by a team ID
• LEFT OUTER JOIN with WHERE clause on 2nd table, not effecting 1st table
• Min() and Max() based on partition in sql server