Database

select isnull([1], 0) as Janeiro,
       isnull([2], 0) as Fevereiro,
	   isnull([3], 0) as Março,
	   isnull([4], 0) as Abril,
	   isnull([5], 0) as Maio,
	   isnull([6], 0) as Junho,
	   isnull([7], 0) as Julho,
	   isnull([8], 0) as Agosto,
	   isnull([9], 0) as Setembro,
	   isnull([10], 0) as Outubro,
	   isnull([11], 0) as Novembro,
	   isnull([12], 0) as Dezembro
from (select month(PP.PAPA_DT_DATAPAGAMENTO) as Mesn, PP.PAPA_RE_VALORPAGAMENTO from PAGAMENTO_PARCELA PP, PAGAMENTO P
     where PP.MOVI_NA_CODIGO = P.MOVI_NA_CODIGO AND P.SUPA_NA_CODIGO = 5) Tab1
pivot (sum(PAPA_RE_VALORPAGAMENTO) for Mesn in ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12])) P1

Hello:

My MySQL database version is 5.6.35 and I use InnoDB.

I want to remove the Delete and Drop Table permissions of the user U1 from the table T1 in the db1 database.
The operating instructions are as follows:

<pre lang="SQL">
Revoke delete,drop on db1.T1 from U1;

Hi,

I am looking a sandwich query for my attendance module, If the employee is absent on Saturday and Monday then sunday will be calculate as Absent the same has to be case of holidays.

The attendance table structure in SQL 2005 as per below.

EmpCode
EmpShift
AttDate
AttStatus
.
.

Please Advice/provide some solution for the above.

Thanks & Kind Regards
Mohammad Salmani