ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more 
PCs.
 Question Submitted By :: Padmavasireddy
I also faced this Question!!     Rank Answer Posted By  
 
  Re: PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
Answer
# 1		 
Select * from PC 
group by hd
having count(*)>1
 
Is This Answer Correct ?    2 Yes 3 No
Guest
 
  Re: PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
Answer
# 2		 
Select hd from PC
Group by hd
having count(hd)<>1
 
Is This Answer Correct ?    5 Yes 0 No
Sandeep
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
Wht is SQL Injection Attack ?  1
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.  7
What is SQL Profiler what is the use of it? 247Customer2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
Can you explain the role of each service?  1
Plz tell about backup&recovery?  2
How will u find the query which is running in some other machine IBM2
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz... Value-Labs5
What is Query Execution Plan? How does it help optimize or tune a database driven application? Accenture1
How to Generate a Series of Random Integers With T-SQL?  1
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!  1
wht's the differece between sqlserver05 and sqlserver2000  3
Wht is the difference between stored procedure and trigger TCS3
How to write stored procedure to update the data in 10 tables  4
wht is normalization?can u explain me in detail? TCS6
How do I list the available tables in a database I'm querying?  3
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
What are the magic tables in SQL Server 2000? Infogain5
What do you mean by COLLATION?  4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com