Posts by Lucas Bicalho • 65 points
4 posts
-
1
votes2
answers166
viewsQ: Count IF Mysql Workbench
i have a table that has an ID field. ID 1234 1234 1235 1235 1235 1236 And I would like to get via query the following result: ID ID_Counter 1234 2 1234 2 1235 3 1235 3 1235 3 1236 1 Where in the…
-
0
votes1
answer1026
viewsQ: Select with max(date), penultimate(date)
I have a chart with product code and date of sale. I would like to make a select by taking the product code, the date of the last sale and the date of the penultimate sale with group by code. It is…
-
1
votes1
answer1791
viewsQ: Decode Base64 mysql
I have a mysql database that some columns of it is encoded in Base64. I’m not familiar with programming to develop a script in another language that decodes. You can create a select in sql that…
-
3
votes2
answers210
viewsQ: Sum if in Mysql Workbench
I have a database in Mysql. No_Pedido|Valor|Cortesia 123|1000|Sim 123|500|Nao 124|200|Nao 124|500|Nao I need to make a select that returns the sum of the value per request that is not courtesy,…