What is the difference between distinct clause and group by
clause?
- 2 Answers
- 15982 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
Do you know what are the ways available in sql server to execute sql statements?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is executereader?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is collation?
How to count duplicated values in a column in ms sql server?
What is sql service broker?
How to find the version of sql server? : sql server database administration
What are the security related catalog views? : sql server security
What do you mean by normalisation?
Explain different types of locks in sql server.
How do you debug a procedure in sql server?
What is outer join in sql server joins?
What is the difference RDBMS and Graph Database?
How to run sql server 2005 books online on your local system?
