Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between HAVING clause and the WHERE
clause?
- 7 Answers
- 16322 Views
- I also Faced
- E-Mail Answers
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
What are the operating modes in which database mirroring runs?
What does nvl stand for?
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?
is there a column to which a default can't be bound? : Sql server database administration
What is data source view or dsv? : sql server analysis services, ssas
How can you find out how many rows returned in a cursor?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is the default order of an order by clause?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Which database stores information about replication?
Define candidate key, alternate key, and composite key.
How do I find the query plan in sql server?
How to replace null values in expressions using isnull()?
What are the instances when triggers are appropriate?
How can we determine what objects a user-defined function depends upon?
