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
- 23596 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
Define self join in sql server joins?
What are the filtered indexes?
What do you mean by the term 'normalization'?
How to select an exiting database using mssql_select_db()?
How can windows applications connect to sql servers via odbc?
Can we delete data from a view?
Can we add an identity column to decimal datatype?
Does sql server 2000 clustering support load balancing?
What is onf in normalization form?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is microsoft sql server?
Explain what is sql server english query?
What are system databases into sql server (2005/2008) : sql server database administration
What is the stuff and how does it differ from the replace function?
Explain left outer join and right outer join?
