select hd from PC group by hd having count(model) >= 2

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

Question Posted / rafal

Answer Posted / rafal

select hd
from PC
group by hd having count(model) >= 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain triggers?

1009

What is 2nf normalization?

1029

List all types of constraints in sql server?

1045

How do I view views in sql server?

1010

How to apply filtering criteria at group level with the having clause in ms sql server?

1002

What happens if we shrink log file in sql server?

983

What are four major operators that can be used to combine conditions on a where clause?

1054

can an order by clause be used in a creation of a view?

1183

What are a scheduled jobs?

956

What is openxml in sql server?

1171

List some of the rules that apply to creating and using a ‘view’

888

Explain about local stored procedure?

972

How to add a new dsn with the odbc driver for sql server?

1060

What is the order by used for?

1024

How to handle error or exception in sql?

983