Question d’entretien chez Ingram Micro

What is difference between where and have statement in SQL?