what is Difference between Having and Where clause?

Answer Posted / joe

When we used group by that time only we can use having. But without group by we can use having.
Only grouped column have used in having condition

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of functions are there in sql?

501


How do you write a subquery?

517


What do we need to check in database testing?

554


What does the sign mean in sql?

505


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

489






How do you remove duplicate records from a table?

509


Can we enter data in a table in design view?

516


What is the main reason behind using an index?

550


What are the constraints available in sql?

575


What is sql in oracle?

623


What is an inner join sql?

542


What is schema in sql example?

595


What is offset in sql query?

593


What are the popular database management systems in the it industry?

560


How to download oracle sql developer?

657