adspace


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



Answer Posted / cullen

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1022


Disadvantages of the indexes?

1222


What is self contained sub query?

1139


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

1078


Explain “row_number()” in sql server with an example?

1078


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


Why we use the openxml clause?

1078


How do I find query history in sql server?

1022


what is the difference between openrowset and openquery?

1193


How can you append an identity column to a temporary table?

1069


How to enter binary string literals in ms sql server?

1243


What is a scheduled job or what is a scheduled task?

1037


How can we solve concurrency problems?

1121


What is subquery? Explain the properties of a subquery?

1058


What is a coalesce function?

1282