What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / senthil kumar t
Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Explain some stored procedure creating best practices or guidelines?
Why de-normalization required?
What is a dbms wizard?
Describe in brief databases and sql server databases architecture.
What is a trace frag?
How do I create a stored procedure in sql server?
Explain intellisense for query editing
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
How many types of functions are there in sql server?
What is check constraint in sql server?
what exactly sql injuction.how to overcome.....
How can you ensure that the database and sql server based application perform well?
What command must you use to include the not null constraint after a table has already been created?
How to enter date and time literals in ms sql server?
what types of replication are supported in sql server? : Sql server database administration