What is the difference between distinct clause and group by
clause?
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 public role in sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Which joins are sql server default?
How can sql server instances be hidden? : sql server security
What is the data tier application?
Does sql server use java?
Explain try...catch with sql server?
What are indexes in ms sql server?
How do I create a trace in sql server?
What are the types of database schema? : sql server analysis services, ssas
Tell me what are the advantages of using stored procedures?
Write SQL queries on Self Join and Inner Join.
What are distributed partitioned views?
What is snapshot parameter in ssrs?
What are partitioned views?