Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16692 Views
- HHH, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rkvenky
distinct suppress the duplicates of data in the select stmt.
where as group by combines the data which we willgive in
order.
2.group by used at the end of select stmt
distint used in select stmt to columns
3.
group by is function where distinct is keyword
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
What are trace flags and mention a few common trace flags used with sql server?
Why I have to use stored procedures?
What is logon trigger?
What is trigger in salesforce?
Explain use of expression builder.
What is spid in sql server profiler?
what is database replication? : Sql server database administration
Do you know what is rank function?
What are the different kinds of ssrs reports?
What is sqlservr.exe - process - sql server (sqlex?press)?
What are policy management terms?
how to control the amount of free space in your index pages? : Sql server database administration
How you can find out if an index is useful to the optimizer?
What is change data capture (cdc) feature?
What is the difference between Normalization and De-normalization?
