What is the difference between distinct clause and group by
clause?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rkvenky
distinct suppress the duplicates of data in the select stmt.
where as group by combines the data which we willgive in
order.
2.group by used at the end of select stmt
distint used in select stmt to columns
3.
group by is function where distinct is keyword
Is This Answer Correct ? | 8 Yes | 13 No |
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the difference between DataRow.Delete() and DataRow.Remove()?
What happens when unicode strings concatenate with non-unicode strings?
What is the significance of master, tempdb and model databases?
What are the basic functions for master, msdb, model, tempdb databases?
can you any body tell me which service pack is installed in the sql server?
What is the difference between upgrade and migration in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the features of Embedded SQL
What are the elements of dbms?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is triggers in ms sql server?