Richard Korts
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER