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 about merge replications?

1034

Can sql server 2016 run on windows 7?

925

What are the benefits and tasks of object explorer? : sql server management studio

1189

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1014

What is the parse query button used for?

1042

Is it possible for a stored procedure to call itself or recursive stored procedure?

955

Why I can not enter 0.001 second in date and time literals in ms sql server?

1070

What command is used to rename the database?

1021

How do I open a .db file?

1047

What is meant by datasource?

932

Do you know concepts and capabilities of sql server?

1070

What do you understand by the analysis services in sql server?

949

How to convert a numeric expression from one data type to another?

1027

What is nolock hint in sql server 2008

1134

Describe how to use the linked server?

1149