Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16724 Views
- HHH, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / swamy
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 ? | 24 Yes | 5 No |
Post New Answer View All Answers
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Tell about MOM Tool(Microsoft Operator Manager)?
Explain sql server authentication modes?
How to find index size for each index on table?
How to use group functions in the select clause in ms sql server?
What is inner join in sql server joins?
What Are the Main Features of SQL Azure?
Write an SQL query to obtain the 2nd highest salary.
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details?
What are diverse clauses that form a part of sql?
What are the steps to process a single select statement?
How to reaname table name without using sp_Rename in sql server..?
What are the different types of collation sensitivity in sql server?
