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



Answer Posted / sandeep

Select hd from PC
Group by hd
having count(hd)<>1

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a SQL queries on Self Join and Inner Join.

611


Define right outer join?

540


Should you normalize audio?

521


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

597


What is it unwise to create wide clustered index keys?

575






how to define testing of network layers? : Sql server database administration

478


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

560


What is an indice?

565


What is dimension table? : sql server analysis services, ssas

554


What are sql servers used for?

500


What is the full form of ddl?

499


Do you know what is fill factor and pad index?

556


What is the difference between online clustering and Offline clustering?

1908


What are the basic functions for master, msdb, model, tempdb and resource databases?

545


What are the difference between clustered and a non-clustered index?

580