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
Explain about merge replications?
When would you use the stored procedures or functions?
what is the system function to get current user's user id? : Sql server database administration
What language is sql server written in?
what's the information that can be stored inside a bit column? : Sql server database administration
When to use null data driven subscription?
List down some advantages of sql stored procedure?
Explain where clause?
what are triggers? : Sql server database administration
Can we use where and having clause together?
What is the difference between ‘having’ clause and a ‘where’ clause?
Explain stored procedure?
How to choose all records from the table?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How to delete database objects with "drop" statements in ms sql server?