what is Difference between Having and Where clause?
Answer Posted / nrapendra
where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what are the different functions in sorting an array? : Sql dba
How do you bind variables in pl sql?
Why do we use triggers?
What is the use of procedures?
How can you create an empty table from an existing table?
How long does it take to learn pl sql?
How many sql statements are used? Define them.
What are different methods to trace the pl/sql code?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Is a foreign key always unique?
Which is better cte or subquery?
What is the difference between in and between in sql?
What is difference between sql and excel?
explain the difference between bool, tinyint and bit. : Sql dba