Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16715 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 the grouping functions?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
Explain external key management in sql server 2008
Can we write ddl in trigger?
Explain the microsoft sql server delete command?
What is read uncmmited?
Which table keeps the locking information?
What are the types of user defined functions in sql server?
What is implicit cursors?
Explain isolation levels that sql server supports?
How to create a new table in a given schema?
What are the methods used to protect against sql injection attack?
What is SQL Azure?
Is it true, that there is no difference between a rule and a check constraint?
