asked
Trying to write a SQL query to display only the “part number” with multiple warehouse “locations”
Trying to write a SQL query to display only the "part number" with multiple warehouse "locations". I want a search that will display each "partno" that has more than one "boxSize" and/or "boxLocation". There is only one table where the data that I need resides. SELECT DISTINCT partno, COUNT(partno) AS MULTIPLE_PARTNO FROM [Reports].[dbo].[Data_all] GROUP BY partno HAVING COUNT(partno) <> '1'
Great question! Try This: SELECT partno, boxSize, Count(partno) as MULTIPLE_PARTNO FROM [Reports].[dbo].[Data_all] WHERE partno IN (SELECT partno FROM [Reports].[dbo].[Data_all] GROUP BY partno HAVING COUNT (partno) >1) This is assuming that PartNo only appears more then once when it has more then 1 boxSize. Let me know if that works.
15 People are following this question.
