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

What is cursors? And what are the different types of cursor?

1145

Explain logical operators in sql server?

1110

What happens on checkpoint?

1024

what are the new features introduced in sql server 2000? : Sql server database administration

921

What is an expression in ms sql server?

1076

How to convert a unicode strings to non-unicode strings?

1102

What is failover clustering overview?

1090

What are orphan records?

932

What happens if you add a new index to large table?

942

What are null values in ms sql server?

1089

Does partitioning improve performance sql server?

983

How would you use user_constraints table in DB?

1008

What is the syntax for encrypting a column in SQL Server?

1121

What is the difference between coalesce() & isnull()?

1132

How to create a testing table with test data in ms sql server?

1084