Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16814 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
Can you explain important index characteristics?
Can we call stored procedure in view in sql server?
What happens if date-only values are provided as date and time literals?
What is an index in a database?
What is lock escalation and what is its purpose?
What is optimization and its types?
Define left outer join in sql server joins?
Which Model uses the SET concept
How to generate create procedure script on an existing stored procedure?
What is the library index called?
List out what other servers you can use with ssrs?
What is the difference between ddl and dml?
What are the different types of replication you can set up in sql server?
What is the difference between grant and with grant while giving permissions to the user?
Can I save my report as html, excel or word? : sql server management studio
