Posts by Herbert Vianna • 39 points
4 posts
-
0
votes1
answer124
viewsA: Query to bring 1 parent record and in it can contain multiple children records (performance)
Hello, Nicola! When the volume of data is very large and I have the possibility to reduce the volume of data I will have to handle, I use Ctes(Common Table Expressions). I create one or more Ctes…
-
1
votes2
answers53
viewsA: Doubts about an algorithm problem
Speak up, Arashi, speak up! Then, the exercise prompts you to write the return of the 4 operations, concatenated with the text "Result:" at the beginning of the text. In case you had any questions…
algorithmanswered Herbert Vianna 39 -
0
votes2
answers335
viewsA: Disable Vba Excel View Mode
Only go in the options. File->Options. Adjust in Reliability Center.…
-
2
votes1
answer590
viewsA: DOUBT SELECT WITH INNER JOIN AND COUNT
I didn’t see any date field to filter the date of purchases by year, but I tried to bring the query as close as possible. Try it on your computer and adjust what you need. select cli.nome_cliente,…