What is the difference between distinct clause and group by
clause?
- 2 Answers
- 15385 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
Write a query for primary key constraint with identity key word?
List few advantages of stored procedure.
What are the aggregate and scalar functions?
Mention the differences between sql server and mysql.
What is deploy, process and build? : sql server analysis services, ssas
What are triggers? How do you invoke a trigger on demand?
Can you insert NULL in unique column?
What is the command dbcc checkdb used for?
How do you create a data source?
Can coalesce return null?
What is explicit mode in sql server?
What is the difference between join and inner join?
What is a data source file?
What are different types of replication in sql server?
List the different normalization forms?
