Posts by Gabriel Sarzi • 25 points
2 posts
-
0
votes1
answer30
viewsQ: Concatenate lines into one
Good afternoon, I need to unify some data, when I bring this so: id 2017 2017-LOJA 2018 2018-LOJA 1 n n s s 1 s s n n Would like so: id 2017 2017-LOJA 2018 2018-LOJA 1 s s s s consultation I made:…
-
1
votes2
answers169
viewsQ: How to Make a Scan in SQL
| cliente | id | cpf | cpf_valido 2 | 1234 | 1 3 | 1234 | 1 5 | 4567 | 0 and I need to set up the table like this | de_para | id | id_para | cpf 2 | 3 |1234 3 | 3 |1234 5 | 5 |4567 To summarize,…