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

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

Question Posted / alci

Answer Posted / alci

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Difference between primary key and clustered index?

1010

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

What do you mean by stored techniques? How would we use it?

1035

What are different types of statements that are supported by sql?

1047

What are the disadvantages of indexes?

1090

How do you create a clustered index?

1056

Will sql server 2005 allow you to reduce the size of a column?

992

What is table value parameters (tvp)?

1101

Explain what is lock escalation?

1067

Can two tables share the same primary key?

928

What is b tree index?

915

How to create an multi-statement table-valued function?

999

can any body tell me how to know the password of current user in sql server

2073

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1264

How column data types are determined in a view?

962