Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16568 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
Is it possible to update the views? If yes, how, if not, why?
How to add additional conditions in SQL?
What is acid properties?
Which are the olap features?
whats new about truncate in sql server 2008?
What is data source object?
What is an execution plan? How would you view the execution plan?
What is default port number for sql server 2000?
How to download and install the scaled-down database adventureworkslt?
How do you identify a foreign key?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain Reporting Life Cycle?
What is the security principal at the server level that represents your session?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the use of @@spid?
