Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23557 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 are the different types of columns types constraints in the sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
what is a self join? : Sql server database administration
What are subqueries in sql server? Explain its properties.
What is a user-defined function in the sql server and what is its advantage?
Can you import Microsoft Excel data to SSRS?
What is row-level compre?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is change data capture (cdc) feature?
What is difference between delete and truncate commands?
What is difference between sql and sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What does nvl stand for?
Explain the commands in sql server?
Explain active/passive and active/active cluster configurations?
