Dynamic Pivot
- Status: Closed
- Hadiah: $12
- Entri Diterima: 3
Deskripsi Kontes
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
Keahlian yang Disarankan
Entri teratas dari kontes ini
-
DesignPeter Bangladesh
-
kavipadm India
-
tampan6689 Indonesia
Papan Klarifikasi Publik
Bagaimana untuk memulai sebuah kontes
-
Buat Kontes Anda Cepat dan mudah
-
Dapatkan Jutaan Entri Dari seluruh dunia
-
Pilih entri terbaik Unggah file - Mudah!