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

how can you check the level of fragmentation on a table? : Sql server administration

1038

How global temporary tables are represented and its scope?

1015

Can binary strings be converted into numeric or float data types?

1096

What is a transaction and why is it important?

1162

What is view in sql?

951

Which language is supported by sql server?

1063

What is a trigger and types of a trigger?

1028

How to delete existing rows in a table?

1246

What causes index fragmentation?

1045

What is user-defined function?

1034

What are the source of constraints?

978

What are commonly used mssql functions in php?

1142

Would you store your query in a ssrs report or a database server? State the reason why?

157

What new changes are being made in SQL Server?

1268

Explain what is the main purpose of having conversation group?

986