create table #TableTools (id int identity(1,1), name varchar(15), tools varchar(15))

insert into #TableTools values

('mike', 'walker')

,('mike', 'cane')

,('steve', 'walker')

,('mitchel', 'cane')

,('dave', 'cane')

,('mitchel', 'none')

;WITH CTE AS

(

SELECT NAME, ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY NAME)NOS

FROM #TableTools

WHERE Tools = 'Walker' OR Tools = 'Cane'

)

SELECT * FROM CTE

WHERE NOS >1