Question
When you use WHERE clause and when you use HAVING clause
Answers
HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Who makes federal laws?
  • Q Which semiconductor device is used as a voltage regulator and why?
  • Q What is this infamous null pointer, anyway?
  • Q What experience do you have with hardware components?
  • Q How can you organize layers as in photoshop?
  • Q Which are the attributes of Container Managed Transactions?
  • Q Explain with an example how parameters can be passed using registers.
  • Q What are the types of data passing mechanisms under JMS specification?
  • Q What is anatomical dead space
  • Q What functionality do i lose as a result of the performance improvements?
  • Q I converted to Islam after having practiced my earlier faith for many years. I have been told that I should adopt a Muslim name. But that would mean enormous difficulties vis-à-vis government work, bank formalities and professional difficulties, not to speak of social problems. Is it necessary for me to go through all that?