Posts by Marco Antonio Chinarelli • 1 point
3 posts
-
0
votes4
answers68
viewsA: Doubt about Group by
Every time you go to make the sum in a query you need to define what are the items you intend to add up in your case you can use the sum for quantity and group per customer and request the query…
-
0
votes2
answers53
viewsA: Select with LEFT JOIN and LIKE
The solution that André Walter passed is the most ideal. If you want to take an excellent SQL course I leave below the link of my course portal www.fpw.com.br/ead There they have the most complete…
-
0
votes2
answers33
viewsA: Query SQL listing shopkeepers by id and status
Use the clause loja_id = "shopkeeper id " AND status <= 5 This way will bring only all logidta IDS ranging from 0 to 5 If you want to take an excellent SQL course I leave below the link of my…