2
Reply

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

Bhasker Das

Bhasker Das

18 years ago
13.6k
0
Reply

    when we are using group by clause to apply condition on group of rows Having clause will be used.having clause follows Group by clause.

    where clause will be used for condition on single row.

    where clause comes before group by clause

    select empname,salary from employee where empname like '%raj%' group by salary having salary>30000

    Rajender Reddy
    17 years ago
    0

    I don't believe there is any difference except that having clause is used if group by clause is used in the query. Otherwise I think you can use a where clause instead.

    farshad
    18 years ago
    0