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
- 23317 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
Can we perform backup restore operation on tempdb? : sql server database administration
Why use identity in sql server?
Explain the difference between cross join and full outer join?
Can you explain the disadvantages/limitation of the cursor?
Can we use custom code in ssrs?
Can foreign key be deleted?
Mention the 3 ways to get a count of the number of records in a table.
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to Sync Two SQL Azure Databases?
What is the Disadvantage of indexed sequential file.
How you can get the list of largest tables in a database?
How to execute a stored procedure in ms sql server?
What is difference between Datepart() and Datename() in SqlServer?
What is temporary stored procedure?
Explain an automatic checkpoint
