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

Can we use pl sql in mysql?

509


Explain what is a database?

641


How do I use google cloud in sql?

529


What are system versioned tables?

543


List different type of expressions with the example.

544






What are tables and fields?

578


What type of database is cloud sql?

570


What is view explain with example?

512


Explain unique key in sql.

553


How many commands are there in sql?

539


What does trigger mean in slang?

517


What is sql server and ase?

534


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1142


Does pl/sql support create command?

572


how to include comments in sql statements? : Sql dba

537