Posts by Paulo Rosa • 25 points
2 posts
-
1
votes1
answer219
viewsQ: mysql Rank function grouped for a COUNT
I have 3 tables in MYSQL represented here as an example: I need a query that returns a RANK of contracts made grouped by commercial in a given period of time, for example: A query that returns the…
-
1
votes1
answer131
viewsQ: Query string works in Phpmyadmin and does not work in PHP
I have the following query that picks up a date, was tested on phpmyadmin and the Heidisql program successfully: Query Mysql set @rn:=0,@grp:=0,@prevdate:=''; from (select DataEncomenda, @rn:=@rn+1…