1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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



Question Posted / padmavasireddy

Answers were Sorted based on User's Feedback



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

Answer / sandeep

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

Is This Answer Correct ?    16 Yes 1 No

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

Answer / cullen

Select hd from PC
Group by hd
having count(*)>=2

Is This Answer Correct ?    4 Yes 0 No

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

Answer / piko1989

Select distinct hd
from pc
GROUP BY hd
having count(hd)>=2

Is This Answer Correct ?    1 Yes 0 No

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

Answer / alci

Select hd
from PC
group by hd
having count(hd)>1

Is This Answer Correct ?    1 Yes 0 No

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

Answer / rafal

select hd
from PC
group by hd having count(model) >= 2

Is This Answer Correct ?    0 Yes 0 No

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

Answer / guest

Select * from PC
group by hd
having count(*)>1

Is This Answer Correct ?    6 Yes 7 No

Post New Answer

More SQL Server Interview Questions

What is the security principal at the database level that represents your session?

0 Answers  

Do you know what are the reporting services components?

0 Answers  

How to use subqueries with the exists operators in ms sql server?

0 Answers  

Difference between server.transfer and server.execute method?

2 Answers  

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  




sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

What is BLOCK statements in SQL?

0 Answers   HCL,

Can you explain various data region available in ssrs with their use?

0 Answers  

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

Explain insert into select statement?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories