Selecting "distinct multirow sets"
Posted on 2013-06-11
I'm trying to find a way to get a 'distinct' list of 'sets of data' across multiple records.
Basically trying to see the distinct list of operations that are available in a bill-of-material (routing, actually).
Part Seq Operation
partA 10 CUT
partA 20 Weld
partB 10 CUT
partB 20 Weld
partB 30 Grind
partC 10 CUT
partC 20 Weld
I want to see that there is two distinct sets of operations: CUT, WELD and CUT, Weld, Grind.
This is on an ancient Sybase ASE 11.9.2 server, so stuck with SQL89 syntax.
Everything I've tried gives me a distinct list of ops...
Any suggestions appreciated!