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
What is normalisation and its types?
Can we create clustered index without primary key?
what are the differences between char and nchar? : Sql dba
Can you call pl/sql package functions from within a fast formula?
what are the advantages of mysql in comparison to oracle? : Sql dba
How do you know if a relationship is 2nf?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Is full outer join same as cross join?
What is trigger in pl sql?
What is not in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
Write a sql query to get the third highest salary of an employee from employee_table?
What is a string data type in sql?
What is the usage of the distinct keyword?
What is cartesian join in sql?