Posts by im037 • 26 points

• 0

  votes

  2

  answers

  38

  views

  A: Query mysql bring last call without duplicate

  The simplest way would be to put the limit 1 right after ordination. Ending in this way: SELECT * FROM `chamado` where chamado.nomechamado = 'NorJan18' order BY chamado.datahora asc LIMIT 1…

  php html mysql sql database

  answered 5 years, 4 months ago im037 26

• 1

  votes

  1

  answer

  56

  views

  A: Select after select result

  Good afternoon, For your query to work only use the GROUP BY. I took the liberty of editing the query to gain performance. Use this way, it should work SELECT DISTINCT TIPO_ATIVIDADE AS ATIVIDADE,…

  mysql sql mysqli

  answered 5 years, 4 months ago im037 26