What is the difference between distinct clause and group by
clause?
- 2 Answers
- 15375 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
Explain full-text indexing?
How can we get count of the number of records in a table?
How can I create a new template for import ? : sql server management studio
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
explain declarative management framework (dmf) in sql server 2008?
How to use wildcard characters in like operations in ms sql server?
Explain transaction server distributed transaction?
Write a SQL query in order to merge two different columns into single column?
How to download and install sql server 2005 books online?
Do you know the capabilities of cursors?
Do you know clustered and non-clustered index?
What is mean by candidate key?
Does hive support indexing?
What is a filestream?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
