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
- 23571 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Group apply before where clause and distinct apply after
where clause.
So group by is good.
| Is This Answer Correct ? | 4 Yes | 10 No |
Post New Answer View All Answers
Is it possible to create trigger on views?
How to create a local temporary stored procedure?
Explain following error properties?
Mention a few common trace flags used with sql server?
How to use subqueries in the from clause in ms sql server?
How to create a view on an existing table in ms sql server?
How to add more data to the testing table in ms sql server?
What do we have to check in database testing?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the need for group functions in sql?
How many databases instances are there in sql server 2000?
Does sql server use t sql?
How do you implement session management in SQL Server mode?
What is sql server query analyzer?
Where is trigger in sql server?
