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

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

Question Posted / cullen

Answer Posted / cullen

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain transaction server implicit?

1028

What are sp_configure commands and set commands?

1075

What is sql profiler. What are the default templates with it? : sql server database administration

1106

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

967

Is port 1433 secure?

1038

What is Replication?

1107

How can we solve concurrency problems?

1098

Are all views updatable ?

1201

How you would rewrite the sql query to return the customerid sorted numerically?

1046

How to insert data with null values?

1081

Explain about service Broker functions?

1089

What is the difference between delete and truncate statements?

1127

What type of Index will get created after executing the above statement?

1144

Please explain go command in sql server?

1112

How do you clear a log file?

1108