How to select non “unique” rows

by

Try this:

SELECT T1.idA, T1.infos
FROM XXX T1
JOIN
(
    SELECT idA
    FROM XXX
    GROUP BY idA
    HAVING COUNT(*) >= 2
) T2
ON T1.idA = T2.idA

The result for the data you posted:

idaA  infos
201   1899
201   1959

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. SQL select only rows with max value on a column [duplicate]
  3. How to create a MySQL hierarchical recursive query?
  4. Error related to only_full_group_by when executing a query in MySql
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. MySQL Query GROUP BY day / month / year
  8. MySQL Cannot Add Foreign Key Constraint
  9. Grouping into interval of 5 minutes within a time range
  10. SQL counting all rows instead of counting individual rows
  11. Convert timestamp to date in MySQL query
  12. Update a column value, replacing part of a string
  13. MySQL comparison with null value
  14. MySQL Like multiple values
  15. In MySQL, should I quote numbers or not?
  16. Matching all values in IN clause
  17. MySQL add days to a date
  18. INTERSECT in MySQL
  19. mysql dynamic query in stored procedure
  20. Check for x consecutive days – given timestamps in database
  21. How to alter a column and change the default value?
  22. How to select one row randomly taking into account a weight?
  23. Remove special characters from a database field
  24. MySQL – Replace Character in Columns
  25. Sort the rows according to the order specified in WHERE IN clause
  26. update a column by subtracting a value
  27. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment