what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 7957 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan378
in addition to the above correct answers ..
Having Clause allows to add conditions using functions
Ex: COUNT(*) > 2
at on the same phrase of the query. this will be basically
to avoid sub queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does null mean?
What is difference between rownum and rowid?
How to create database with physical files specified in ms sql server?
Can we insert data into a view?
How does index makes search faster?
Do you know what is user defined datatypes and when you should go for them?
What is stored in the mssqlsystemresource database? : sql server database administration
How to modify an existing stored procedure in ms sql server?
How would we use distinct statement? What is its use?
Is it possible to have clustered index on separate drive from original table location?
Explain for xml explicit mode?
How to add more data to the testing table in ms sql server?
What are the types of database schema? : sql server analysis services, ssas
What is view in sql?
What are the underflow and overflow behaviors on float literals?
