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
Top entries from this contest
-
DesignPeter Bangladesh
-
kavipadm India
-
tampan6689 Indonesia
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!