Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 9943 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
Does the order of columns in update statements matter?
How to create user defined functions with parameters?
What is difference between unique and primary key?
What is the security model used in sql server 2005?
How to remove duplicate rows from table?
What are the disadvantages of using querystrings to send data from one page to another?
What are the different kinds of ssrs reports?
How to configure and test odbc dsn settings?
How to see existing views in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain about thread and memory management process of SQL?
What is entity data services?
What is the difference between grant and with grant while giving permissions to the user?
What is @@rowcount in sql?
Explain the truncate command? : SQL Server Architecture
