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
- 21700 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / hitesh kumar vyas s
Performance wise Distinct is more effective than group by.
Since in group by it has to group and then provide the
result but this is not the case in distinct
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
What is a dataset and what are the different types of datasets?
What are the dmvs? : sql server database administration
What command must you use to include the not null constraint after a table has already been created?
Is null in sql server?
how many no of arguments can be passed in procedures and functions
What are the different type of replication in sql server?
what is unique and xaml nonclustered index
What is factless fact table? : sql server analysis services, ssas
What is measure group, measure? : sql server analysis services, ssas
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Can sql server 2016 run on windows 7?
What is cte (common table expression)?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is a trace frag?
What is query processing?
