Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16672 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 do you open a cluster administrator?
What is checkpoint in sql server?
How can i Relate Tables in SSIS
What is model database? : SQL Server Architecture
What are the export options of ssrs?
What is reference section?
What are scalar functions?
What are sql server procedures?
What sql server means?
What is the use of commit?
What do you know about system database? : SQL Server Architecture
Does partitioning help performance?
What does the on update no action do?
How can we rewrite sub-queries into simple select statements or with joins?
what information is maintained within the msdb database? : Sql server administration
