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

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

Question Posted / guest

Answer Posted / guest

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

Is This Answer Correct ?

6 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Which sql server table is used to hold the stored procedure script?

1003

What is @@rowcount in sql?

1056

What is sub-query in sql server?

1257

What are the different types of replication are there in sql server 2000?

1085

What is tcl in sql server?

1166

Explain about Views?

1120

How do I open port 1433?

982

What are the mathematical functions supported by sql server 2005?

1122

What are the options which must be set to allow the usage of optimistic models?

1020

Why do you need a sql server?

1170

What are the tables in sql?

1144

What are the basic functions for master, msdb, model, tempdb databases?

1094

What is a hint?

1052

What are the steps you can take to avoid “deadlocks”?

1021

Write a code to select distinct records without using the DISTINCT keyword.

1178