What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16920 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
Equi join and non equi join is possible with sql server?
What is subquery? Explain the properties of a subquery?
How to connect php with different port numbers?
How do I find the sql server version?
What are the different types of subquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Where can you add custom error messages to sql server?
Why and when do stored procedure recompile?
What are the different SQL Server Versions you have worked on?
Explain system functions or built-in functions? What are different types of system functions?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is temporary table in sql server? Why we use temp table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Is it possible to have clustered index on separate drive from original table location?
