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

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

Question Posted / piko1989

Answer Posted / piko1989

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain “row_number()” in sql server with an example?

1080

Can you index views?

955

Why and when do stored procedure recompile?

1064

What is sql or structured query language?

1228

what is the difference between openrowset and openquery?

1197

What are the kinds of subquery?

1109

What are different types of constraints?

1003

What are the source of constraints?

1010

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024

How to provide default values to function parameters?

1261

Does view occupy space?

1022

What is an indexed view?

1023

What is in place upgrade in sql server?

1127

How do I find query history in sql server?

1025

What are the different subsets of sql?

1654