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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 
What is the difference between distinct clause and group by
clause?
 Question Submitted By :: Ruban
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between distinct clause and group by clause?
Answer
# 1		 
Distinct Clause:
---------------
Distinct Clause Will Eliminate the Duplicate data or Rows 
when u r selecting from table .So it Produce the Data or 
Rows with out Duplication.Generally Distinct Clause  will 
be Placed on the Column of the Table.

Group Clause:
-------------
Group Clause will group or pack the rows or data based on 
the Column(S).
 
Is This Answer Correct ?    4 Yes 1 No
Swamy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is a sub-query? When would you use one?  3
syntax for deleting the database in T SQL  4
What is the datatype returned by count(*) Asian-CERC18
Write a query to delete duplicate records in SQL SERVER Infosys19
what is bit data type? and what are the information that can be stored inside a bit column?  2
What are Sql Reporting Services and analysis services? Can u Explain  1
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro23
Display a roll having miminum marks in two subjects? Patni7
What is the use of MOVE keyword in restore command IBM2
What is the difference between DTS and SSIS? Allianz3
How do we rollback the table data in SQL Server  3
Can anybody explain me cold backup and hot backup? TCS3
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?  2
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com Oracle18
what is Archive old data?  1
Difference between Function and Stored Procedure? C1-India4
What is lock escalation?  1
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions1
Explain the architecture of SQL Server?  2
 
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