Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29157 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / santosh pashupatimath
Having clause is used before aggregation and where clause is
used before aggregation
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are “phantom rows”?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Tell me what is the significance of null value and why should we avoid permitting null values?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How to make a column nullable?
How is SQL Azure different than SQL server?
How to create an index on an existing table in ms sql server?
explain declarative management framework (dmf) in sql server 2008?
How to create sub reports?
define and explain the differences between clustered and non-clustered indexes.
What happens when transaction log is full?
What is the difference between join and inner join?
What are the options which must be set to allow the usage of optimistic models?
Define indexes?
Tell me what do we need queues in sql service broker?
