PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
- 6 Answers
- 13008 Views
- APX, I also Faced
- E-Mail Answers
Answer Posted / piko1989
Select distinct hd
from pc
GROUP BY hd
having count(hd)>=2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is an indexing technique?
What command do we use to rename a db, a table and a column?
When do you think a developer should use sql server-based cursors?
How you can get a list of all the table constraints in a database?
What is the use of nvl work?
please differentiate between delete and truncate?
What is the process of normalising?
What stored procedure can you use to display the current processes?
What is store procedure? How do they work?
What is the use of set nocount on/off statement?
How to round a numeric value to a specific precision?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
what are the reporting service components in SSRS?
How real and float literal values are rounded?
