Select hd from PC Group by hd having count(hd)<>1

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

Question Posted / sandeep

Answer Posted / sandeep

Select hd from PC
Group by hd
having count(hd)<>1

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

State a few properties of relational databases?

1062

Explain the first normal form(1nf)?

972

Explain concepts of analysis services?

893

What is the contrast between sql and pl/sql?

1077

Why use stored procedures in sql server?

959

Please explain what is “asynchronous” communication in sql server service broker?

882

Why SQL Agent is used?

1067

What is the process of normalising?

953

Explain query editor regions

1005

Does partitioning improve performance sql server?

902

How column data types are determined in a view?

904

What is a trigger what are the advantages of trigger?

919

How to enter date and time literals in ms sql server?

956

What are trace flags?

964

What are subqueries in sql server?

1066