What is the difference between having and where clause?
Answer Posted / kundan ravi
having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
what is a mixed extent? : Sql server administration
How is table type constraint applied to a table?
Explain four layers of abstraction microsoft architectured?
How can we use ConnectorJ JDBC Driver with MS SQL?
How many columns can we include on clustered index ?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is read uncmmited?
What are the dis_advantages of stored procedures, triggers, indexes?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How to create “dependant” parameter “make, model, year”
What is difference between foreign key and unique key?
Explain system functions or built-in functions? What are different types of system functions?
What is the purpose of indexing?
What are different types of data sources?