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

optimization techinques

2680

Define inner join in sql server joins?

1061

How to make a remote connection in a database?

977

What is acid db?

886

How to find out the list schema name and table name for the database?

942

What are the differences between stored procedure and the dynamic sql?

1095

Can we join two tables without primary key?

1054

Write a sql query to display the current date?

1094

What are the differences between char and nchar in ms sql server?

1087

tell me the disaster recovery plan

2516

Explain a differential backup?

1010

What are the differences between ms sql server & oracle?

1062

How to find the list of fixed hard drive and free space on server?

1201

What is report subscription?

125

What will be query used to get the list of triggers in a database?

1005