PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
Answer Posted / rafal
select hd
from PC
group by hd having count(model) >= 2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is temporal table?
Describe and explain about SQL native client?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What are the components of sql server service broker?
What do you mean by normalisation?
What are the various editions of sql server 2017 that are available in the market?
What is the difference between Normalization and De-normalization?
How many tables can be joined in SQL Server?
What is join query?
What are statistics?
Explain system rowset functions?
How to use linked server?
How to apply cascading referential integrity in place of triggers?