what is the difference between group and having
give an example with query and sample output
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
Explain what is it unwise to create wide clustered index keys?
What are the character string functions supported by sql server 2005?
What is a result set object returned by odbc_exec()?
Explain different types of lock modes in sql server 2000?
What do you mean by stored techniques? How would we use it?
Why do you want to join software field as you have done your BE in Electronics?
how many bits ip address consist of? : Sql server database administration
What do you mean by cardinality?
What is the command used to check locks in microsoft sql server?
Distinguish between commit and rollback?
How do we Backup SQL Azure Data?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Explain the steps to create and execute a user-defined function in the sql server?
Which command is used for user defined error messages?
What is table valued function and scalar valued functions?