What is the difference between distinct clause and group by
clause?
- 2 Answers
- 15983 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
Can primary key be a foreign key?
What is instead of dml trigger?
How to connect a database with sql express.?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
query processing
What are the different editions available in sql server 2000?
How to fetch the next row from a cursor with a "fetch" statement?
What is key set driven?
Explain partitioned view?
How do triggers work?
How do I uninstall sql server 2014?
What is the security model used in sql server 2005?
What do you mean by an execution plan? Why is it used? How would you view it?
What is CTE in SQL
what's the information that can be stored inside a bit column? : Sql server database administration
