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

How to loop through result set objects using mssql_fetch_array()?

1024

What is tcl in sql server?

1080

Can we use trigger new in before insert?

868

What is not null constraint?

1057

What is the difference between update lock and exclusive lock?

916

What is the security model used in sql server 2005?

937

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

895

What is the meaning of sql server?

937

How do triggers work?

885

What are the database objects? : SQL Server Architecture

987

What are data driven subscriptions?

106

List out the different types of locks available in sql server?

936

If a stored procedure is taking a table data type, how it looks?

6356

How to use subqueries with the in operators in ms sql server?

1015

What is Transparent Data Encryption?

942