what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 7961 Views
- I also Faced
- E-Mail Answers
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
Can I save my report as html, excel or word? : sql server management studio
What is difference between drop truncate and delete?
What do we have to check in database testing?
What are the basic features of a trigger in ms sql server?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What are the advantages of using cte?
How to populate a table in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
Which is better statement or preparedstatement?
What is ddl and dml commands?
What are 3 ways to get a count of the number of records in a table?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the default port for SQL Server over a firewall?
What is the process of indexing?
What is difference between stored procedure and user defined function?
