In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp;
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 are the database roles? : sql server security
What is the benefit of normalization?
Why union all is faster than union?
Explain the properties of a relational table?
What purpose does the model database server?
What is the use of partition by in sql server?
Why do we use functions?
What is dml command?
How do we know if any query is retrieving a large amount of data or very little data?
Explain the database you used in your final year project?
Explain different backup plans?
Explain the stored procedure?
What is the most common type of join?
What is nested transaction?
How to update muliple row in single query?