Questions tagged as 'distinct'

You will see I need to send to ask for an amount n of questions, where that amount is given by a parameter. The query is already functional and sends them to the parameter randomly. What happens now is that it shows questions that are repea...

I have a table with 4 columns id, descripcion_articulo, cantidad, modelo, marca and this query: ("select distinct descripcion_articulo from " . TABLE_ENTREGAS . " where numeracion = '' order by descripcion_articulo ASC") to generate th...

In the previous MySQL version of the hosting this sentence worked for me without problems: "SELECT DISTINCT Mes FROM recogida ORDER BY ID DESC" Where the column ID is unique code for each entry in the table and Month is the month + y...

I have this table of expenses and I need to add the Total column. The problem is that the table takes into account the products, and when making the sum I added several times the total of a note (because in the same note there were seve...