Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

SQL Query

I have a MySQL table with the first column being the Work Order number; see attached image for a sample. In most cases, there are multiple rows per work order. Table name wo_parts.

I want to do a SQL query to look at all rows where there are 10 or more entries for a specific work order.

What is a query that will do that?

Thanks
wo-parts-table.jpg
ASKER CERTIFIED SOLUTION
Avatar of Walter Ritzel
Walter Ritzel
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Korts

ASKER

Perfect