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 syntax for viewing trigger?

927

what exactly sql injuction.how to overcome.....

2546

What is raiseerror? What is raiseerror?

1141

Where cross join is used?

964

How do I view a stored procedure in sql server?

982

What is Extended user-defined?

961

What’s the use of custom fields in report?

944

What is sql server replication? : sql server replication

991

Why do you want to join software field as you have done your BE in Electronics?

2144

Why do we backup Active Directory ?

1043

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1042

What is role playing dimension with two examples? : sql server analysis services, ssas

1006

What are the advantages of using a stored procedure?

1008

When to use null data driven subscription?

206

Can we delete data from a view?

924