Mysql select distinct

Question

I am trying to select of the duplicate rows in mysql table it s working fine for me but the problem is that it is not letting me select all the fields in that query   just letting me select the field name i used as distinct   lemme write the query for better understading  mysql query  SELECT DISTINCT ticket id FROM temp tickets ORDER BY ticket id    mysql query  SELECT     DISTINCT ticket id FROM temp tickets ORDER BY ticket id     1st one is working fine  now when i am trying to select all fields i am ending up with errors  i am trying to select the latest of the duplicates let say ticket id 127 is 3 times on row id 7 8 9 so i want to select it once with the latest entry that would be 9 in this case and this applies on all the rest of the ticket id s  Any idea thanks

User · Accepted Answer

Are you looking for  SELECT    FROM temp tickets GROUP BY ticket id ORDER BY ticket id    UPDATE   SELECT t    FROM   SELECT ticket id  MAX id  as id FROM temp tickets GROUP BY ticket id  a   INNER JOIN temp tickets t ON  t id   a id

User · Answer

DISTINCT is not a function that applies only to some columns   It s a query modifier that applies to all columns in the select-list  That is  DISTINCT reduces rows only if all columns are identical to the columns of another row  DISTINCT must follow immediately after SELECT  along with other query modifiers  like SQL CALC FOUND ROWS    Then following the query modifiers  you can list columns   RIGHT  SELECT DISTINCT foo  ticket id FROM table    Output a row for each distinct pairing of values across ticket id and foo   WRONG  SELECT foo  DISTINCT ticket id FROM table    If there are three distinct values of ticket id  would this return only three rows   What if there are six distinct values of foo   Which three values of the six possible values of foo should be output  It s ambiguous as written

User · Answer

You can use group by instead of distinct  Because when you use distinct  you ll get struggle to select all values from table  Unlike when you use group by  you can get distinct values and also all fields in table

User · Answer

You can use DISTINCT like that mysql query  quot SELECT DISTINCT ticket id   column1  column2  column3  FROM temp tickets  ORDER BY ticket id quot

User · Answer

use a subselect    http   forums asp net t 1470093 aspx

[mysql] Mysql select distinct

Examples related to mysql

Examples related to select

Examples related to greatest-n-per-group