what is the difference between group and having
give an example with query and sample output
Answer Posted / veeresh kethari
Where: 'WHERE' will filter the data before grouping
Having:'HAVING' will filter,after the grouping the data.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
List the different normalization forms?
Can you explain what is sql server english query?
What is 2nf normalization?
Explain in details security in SQL azure?
What types of replication are supported in sql server?
Can we insert data if clustered index is disabled?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How do you delete duplicate rows in sql server?
What are the database objects? : SQL Server Architecture
Can we insert data into a view?
What is store procedure?
What are character string data types in ms sql server?
Which are the important points to note when multilanguage data is stored in a table?
What are the advantages of sql azure?
What have included columns when we talk about sql server indexing?