How to get the PC models with identical speed?
This should do the trick:

select distinct 
  pca.model, pcb.model, pca.speed, pca.ram
from pc pca 
join pc pcb 
  on (pca.speed = pcb.speed 
  and pca.ram = pcb.ram 
  and pca.model &gt; pcb.model)