Select * from PC group by hd having count(*)>1

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

Question Posted / guest

Answer Posted / guest

Select * from PC
group by hd
having count(*)>1

Is This Answer Correct ?

6 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is thr feature of change data capture?

920

How can we determine what objects a user-defined function depends upon?

953

what is denormalization and when would you go for it? : Sql server database administration

1118

What is the difference between update lock and exclusive lock?

914

What are statistics?

953

List the different types of joins?

929

What is mapping schema?

988

What is the use of =,==,=== operators?

960

Is it ok to shrink transaction log?

939

Explain indexes disadvantages?

1011

Why are sql functions used?

1048

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1007

What is onf in normalization form?

1002

Which sql server table is used to hold the stored procedure scripts?

1027

How many types of the database links?

1025