| Author |
 Topic  |
|
|
jdrella17
Starting Member
3 Posts |
 Posted - 09/28/2012 : 21:05:32
|
I am fairly new to SQL Server and I am having some trouble pairing common fields as pairs. Here is the example of the problem: List Part_Num, "Description", and Class for each pair of parts that are in the same class. (EX...AT94 and FD21 are a pair because they are in the same class-HW). Here is a partial table for parts.
PART_NUM DESCRIPTION CLASS
AT94 Iron HW
BV06 Home Gym SG
CD52 Microwave Oven AP
DL71 Cordless Drill HW
DR93 Gas Range AP
DW11 Washer AP
FD21 Stand Mixer HW
KL62 Dryer AP
KT03 Dishwasher AP
KV29 Treadmill SG
Any advice or help would be greatly appreciated. A brief explanation would be fantastic. Thank you all in advance. |
|
|
khtan
In (Som, Ni, Yak)
Singapore
17689 Posts |
Posted - 09/28/2012 : 23:41:57
|
how do you want the result to looks like ?
KH
Time is always against us
|
 |
|
|
jdrella17
Starting Member
3 Posts |
Posted - 09/29/2012 : 00:08:27
|
| You know, that is a great question. I guess I should have asked that because thinking about it, I am not even sure. I originally was thinking on using GROUP BY, but then that would list all items in class HW and not pairs. The more I read this question, the more confused I get. If you have any suggestions, feel free to let me know. Honestly, I am not even understanding what it is asking. If you are wondering, yes, this is for an ungraded challenge assignment. It is just starting to consume me so now I need to know the output |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
17689 Posts |
Posted - 09/29/2012 : 00:16:11
|
probably just
ORDER BY CLASS ?
KH
Time is always against us
|
|
|
|
jdrella17
Starting Member
3 Posts |
Posted - 09/29/2012 : 00:55:19
|
I figured it out and I did group it by class. For anyone that is curious, here it is.
select a.Part_Num, a."description", a.class, b.part_num, b."description", b.class
from PART a, part b
where a.CLASS = b.CLASS
and a.PART_NUM < b.PART_NUM
order by a.class, b.class ;
Thanks for the help. I know it wasn't much, but you did attempt to help me out. Very much appreciated. |
|
|
| |
Topic |
|
|
|
Grouping as pair