What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / srinivas
HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.
| Is This Answer Correct ? | 35 Yes | 4 No |
Post New Answer View All Answers
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Which data type columns are the best candidates for full-text indexing?
What is outer join in sql server joins?
Explain having clause?
How to use user defined functions in expressions?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Explain how dts is used to extract, transform and consolidate data?
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 ?
What are the tables in sql?
How to create a local temporary stored procedure?
Explain different types of Normalization.
What objects does the fn_my_permissions function reports on? : sql server security
What is after dml trigger?
How to start sql server browser service?
How do we synchronize On-Premise SQL server with SQL Azure?