adspace


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



Answer Posted / alci

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we shrink data file in sql server?

1126


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132


Disadvantages of the indexes?

1222


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022


List the ways in which dynamic sql can be executed?

1085


How to connect php with different port numbers?

1186


How do I start sql server 2017?

1015


When should you use an instead of trigger?

1051


what is the difference between openrowset and openquery?

1193


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1298


How to provide default values to function parameters?

1256


How do I find query history in sql server?

1022


What is sql server query analyzer?

1126


How to rebuild the master database?

1165


What are the different SQL Server Versions you have worked on?

1077