Doonie Darkoo questions

• How to get MAX ID while grouping on specific column?
• Get monthly attendance
• Calculate duration in years if months increases from 12 months
• Add extra rows in result set of query with dummy data in sql server
• Opening and Closing Balance Sum
• How to exclude same rows in SELECT
• How to dynamically allocate all months based to a column on condition in SQL Server?
• Get all dates between provided dates

Doonie Darkoo answers