What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16921 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
How to provide default values to function parameters?
How raid can influence database performance?
Explain “row_number()” in sql server with an example?
How to rebuild the master database?
Where can you add custom error messages to sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is the primary use of the model database?
What is acid mean in sql server?
How do I find query history in sql server?
What are the source of constraints?
What is clustered index
How can you append an identity column to a temporary table?
what is spatial nonclustered index
Why and when do stored procedure recompile?
When should you use an instead of trigger?
