what is Difference between Having and Where clause?

Answer Posted / ganesh

where clause check a condition & having clause is use in
group by clause

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the parts of a basic sql query?

723


what is index? : Sql dba

747


What are sql procedures?

759


How many types of primary keys are there?

710


How do you use a while loop in pl sql?

719






What is the difference between the conventional and direct path loader? : aql loader

867


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

843


Are subqueries better than joins?

718


What are the most important characteristics of pl/sql?

782


Can we join tables without foreign key?

693


What are sql built in functions?

677


How do I view a view in sql?

697


what is 'mysqlcheck'? : Sql dba

746


What is the difference between cross join and natural join?

753


what is an alias command? : Sql dba

727