Posts by Edmilson Alves • 36 points
3 posts
-
0
votes4
answers91
viewsA: Select with columns stating incorrect data
Andrew, There is a command in sql named row_number, it makes a list according to the parameters. Access the link below and see the example. http://www.postgresqltutorial.com/postgresql-row_number/ I…
-
2
votes1
answer227
viewsA: Query Mysql three tables
Joan, the result print is what you expect, right? Your query is wrong, since you are wanting all the modules there is no need for you to use right join. --Nesse select você vai relacionar todos os…
-
0
votes2
answers50
viewsA: Select only 1 record per month with an aggravating factor that prevents the use of Group By
You can do this in many ways. The problem will be if you have more than one sale in the same day. SELECT i.loja, i.nome, i.tipo, i.data, RANK() OVER (PARTITION BY i.loja, i.nome ORDER BY i.data…