Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16669 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 is the distinction amongst delete and truncate?
What are 3 ways to get a count of the number of records in a table?
Mention the differences between having and where clause.
What is inline variable assignment?
What is b tree index?
What is the difference between osql and query analyzer?
Explain optimistic and pessimistic concurrency?
What is the concept of optimization?
What is NOT NULL Constraint in sql server 2012?
What are the diifferences between the ms sql server vs mysql?
What is normalization 1nf 2nf 3nf?
What is the filtered index?
What is compression - row-level and page-level compression?
Do you know what are the restrictions that views have to follow?
Difference between primary key and clustered index?
