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 / alci

Answer Posted / alci

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is resultset an interface?

1037

What is the purpose of floor function?

1092

What is mean by dml?

1060

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

1109

Can a table have 2 foreign keys?

956

What is open database communication (odbc)?

1115

What is the difference between TRUNCATE and DROP?

1189

How do triggers work?

994

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1222

Explain some stored procedure creating best practices or guidelines?

1002

How to enable/disable indexes?

1123

How to find index size for each index on table?

1053

What are the authentication modes in sql server? How can it be changed?

1193

How to define output parameters in stored procedures?

1083

What is surrogate key? : sql server analysis services, ssas

1160