Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16713 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
Why I have to use stored procedures?
Delete duplicate rows without using rowid.
Explain what is “asynchronous” communication in sql server service broker?
What is best institute to Learn DotNET And SQL in chennai?
What is function of ROLLUP ?
What have included columns when we talk about sql server indexing?
Do you know the different ddl commands in sql?
Can another user execute your local temporary stored procedures?
What is a Join and explain its types?
Can you explain different types of locks in sql server?
Explain what are the events recorded in a transaction log?
Define full outer join in sql server joins?
What languages bi uses to achieve the goal?
What are the essential components of sql server service broker?
What is use of @@ spid in sql server?
