Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16804 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 stored procedure would you use to view lock information? : Sql server administration
What is the difference between update lock and exclusive lock?
How to create a simple table to test triggers in ms sql server?
What are audit control procedures?
What are the functions in sql server?
Explain ranking functions?
How to find Duplicate Records In table?
When do you think a developer should use sql server-based cursors?
How is sql server used?
What is join and name different type of joins?
What is schemabinding a view?
What is Service Broker in sql server 2012?
How to get all stored procedures in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
List the different types of joins?
