Questions tagged as 'sql-select'

Next I have a table named telefonia_numero and inside it there is a field called Numero where it contains all the user's phone.    Ex. Jose - Number 81 3636-1145, 81 99873-7787 and 9873-7787, Here comes what I want. I...

Let's take the table below as an example: id empresa forneedor 1 10 105 2 10 102 3 10 105 4 10 112 5 10 105 Using business and vendor as indexes. Making SELECT * FROM table...

Good afternoon guys, I'm new to the forum and I have a problem, I think it's simple in sql, it duplicates the result, can anyone help me? SELECT DISTINCT o.id, s.id, s.servico, s.descricao, s.valor, s.orcamento_id, p.id,...