-1

mysql group_concat function using sub-query in condition I want to try as below :

SELECT * FROM  prologic WHERE ID IN (

SELECT GROUP_CONCAT( DISTINCT ID ) from ( 
SELECT GROUP_CONCAT( DISTINCT ID )ID
FROM  `prologic` 
GROUP BY Vendor_Code
HAVING COUNT( * ) >1
)c
)

Please guide me to solve it.

Ajeet Kumar
  • 156
  • 1
  • 10

1 Answers1

0

SELECT * FROM prologic WHERE ID IN ( SELECT DISTINCT ID FROM prologic GROUP BY Vendor_Code HAVING COUNT( * ) >1 )

Ajeet Kumar
  • 156
  • 1
  • 10