Select hd from PC Group by hd having count(*)>=2

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

Question Posted / cullen

Answer Posted / cullen

Select hd from PC
Group by hd
having count(*)>=2

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do we synchronize On-Premise SQL server with SQL Azure?

120

What is merge?

935

What are the character string functions supported by sql server 2005?

937

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

What is the main purpose of having conversation group?

848

What is difference between rollback immediate and with no_wait during alter database?

1017

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

992

Explain ms sql server reporting services vs crystal reports?

858

what is isolation level at dead lock?

2090

Explain why variables called the most powerful component of ssis?

995

Explain some stored procedure creating best practices or guidelines?

872

How to update muliple row in single query?

1003

What are recommended options to be used while using db mirroring? : sql server database administration

1072

Explain for xml explicit mode?

914

What is difference between stored procedure and user defined function?

1033