Posts by Fábio Roberto Teodoro • 142 points

• -2

  votes

  2

  answers

  45

  views

  A: A separate city sql query

  You will need two queries, one with city='Brasilia' and the other with city<>'Brasilia'. And join the two with UNION.

  mysql sql

  answered 7 years, 1 month ago Fábio Roberto Teodoro 142

• 3

  votes

  1

  answer

  160

  views

  A: Know the position on a listing

  If you are using Postgresql, for example, this function on php is not necessary and you can write an SQL that returns only the author you want, with the ranking and number of comments. With this…

  php database pdo query

  answered 7 years, 1 month ago Fábio Roberto Teodoro 142