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
Explain throw statement in sql server 2008?
What is nonclustered index on computed columns?
Explain the Ways to improve the performance of a sql azure database?
How to create user defined functions with parameters?
How many servers can we create in a single subscription?
Explain some stored procedure creating best practices or guidelines?
How sql server executes a statement with nested subqueries?
Write a program using SQL queries to find a unique entry in a table.
How to create median function?
Why olap is used?
What are a database and a data warehouse?
How do I create a stored procedure in sql server?
What is normalization? What number of normalization shapes are there?
What are the different types of triggers in SQL SERVER?
What is the cpu pressure?