In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp;
- 5 Answers
- 21699 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
In SQL Server 2000:
-------------------
A DISTINCT and GROUP BY usually generate the same query
plan, so performance should be the same across both query
constructs. GROUP BY should be used to apply aggregate
operators to each group. If all you need is to remove
duplicates then use DISTINCT. If you are using sub-queries
execution plan for that query varies so in that case you
need to check the execution plan before making decision of
which is faster.
Example of DISTINCT:
--------------------
Query:
select DISTINCT Book_Title,COUNT(*) from bookdetails
Answer:
Server: Msg 8118, Level 16, State 1, Line 1
Column 'bookdetails.Book_Title' is invalid in the select
list because it is not contained in an aggregate function
and there is no GROUP BY clause.
Example of Group By:
--------------------
Query:
select Book_Title,COUNT(*) from bookdetails group by
Book_Title
Answer:
ASP 1
C 1
C++ 1
Oracle 1
SQL Server 1
VB.Net 3
Visual Bsic 1
In this Answer, the VB.NET is Duplicate, it having this
table in 3 times.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Define cursor locking
What is a collation in ms sql server?
What it means to be triggered?
How do I open a .db file?
When you use @@error and try-catch?
Can group by and orderby be used together?
What is a partition key?
When we should use @@error?
what is denormalization? : Sql server database administration
What is difference between rollback immediate and with no_wait during alter database?
What is data mart? : sql server analysis services, ssas
What are the difference between “where” and “having” clause in sql server?
How to write an inner join with the where clause in ms sql server?
What is the full form of dql?
What is order of B+tree?
