PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
Answers were Sorted based on User's Feedback
Answer / sandeep
Select hd from PC
Group by hd
having count(hd)<>1
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / cullen
Select hd from PC
Group by hd
having count(*)>=2
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / piko1989
Select distinct hd
from pc
GROUP BY hd
having count(hd)>=2
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rafal
select hd
from PC
group by hd having count(model) >= 2
| Is This Answer Correct ? | 0 Yes | 0 No |
How we can refresh the view?
What happens if null values are involved in datetime operations?
what is cluster and nin-cluster index?
What is primary key, unique key, and foreign key?
What is named calculation? : sql server analysis services, ssas
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
wat is tuff file in log shipping, wt is d use of tht file?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is sql server query analyzer?
How to Install SQL SERVER 2005 remotely?
what happens on checkpoint? : Sql server database administration
Which one is faster delete/truncate? Why?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)