Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16807 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 is a join in sql? What are the types of joins?
What is the index requirement in SQL Azure?
How do I install only the client tools of sql server 2000?
What is the difference between a function and a trigger?
How to provide values to stored procedure parameters in ms sql server?
How do I find the query plan in sql server?
How many primary keys are possible in a table?
How to move database physical files in ms sql server?
What are the different editions available in sql server 2000?
What is cdc in sql server?
Mention the differences between local and global temporary tables.
Explain error handling in ssis?
Why do you want to join software field as you have done your BE in Electronics?
Explain system functions or built-in functions? What are different types of system functions?
What are logical/boolean operations in ms sql server?
