what is Difference between Having and Where clause?

Answer Posted / tanmoy

We can use arithmetic operator in having clause but it is
not possible for where clause..

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are indexes and views important to an organization?

520


What is varchar sql?

606


What is clause?

604


How do I partition in sql?

531


What is the difference between the implicit and explicit cursors?

517






What is having clause in sql?

520


What is cursor in pl sql?

567


How can you know that statistics should be updated?

597


Is sql developer case sensitive?

510


How do I run a sql query?

525


What does sign mean sql?

561


What are the packages in pl sql?

564


Can we call a function containing dml statements in a select query?

537


When are we going to use truncate and delete?

546


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

536