Dynamic Pivot

• Status: Closed
• Prize: $12
• Entries Received: 3

Contest Brief

MYSQL QUERY CHALLENGE (FUN CHALLENGE)

I have a contest. Its simple but tricky. I have a table with three columns with name, attendance status and date. Output sheets are also shown in the file. If the month is 30 days then it should be 30 days and if it is 31 days then 31 days.

If the day is Sunday then it should show SU and if the employee is on any leave, even on a Sunday it should show the leave.

I have solved the problem, i want to see who can do it in a simple dynamic pivoting style.

Lets see who wins the challenge.

It should be an MySql query

Recommended Skills

• MySQL