PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are e

PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.

Question Posted / padmavasireddy

Answers were Sorted based on User's Feedback

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / sandeep

Select hd from PC
Group by hd
having count(hd)<>1

Is This Answer Correct ?

16 Yes

1 No

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / cullen

Select hd from PC
Group by hd
having count(*)>=2

Is This Answer Correct ?

4 Yes

0 No

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / piko1989

Select distinct hd
from pc
GROUP BY hd
having count(hd)>=2

Is This Answer Correct ?

1 Yes

0 No

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / alci

Select hd
from PC
group by hd
having count(hd)>1

Is This Answer Correct ?

1 Yes

0 No

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / rafal

select hd
from PC
group by hd having count(model) >= 2

Is This Answer Correct ?

0 Yes

0 No

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or mo..

Answer / guest

Select * from PC
group by hd
having count(*)>1

Is This Answer Correct ?

6 Yes

7 No