Answer / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Answer / ganesh

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

Answer / nrapendra

where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause

Answer / 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

Answer / tanmoy

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

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

What do you understand by pl/sql records?

0 Answers  

---

What is raw datatype in sql?

0 Answers  

---

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

How do I create an index in word?

0 Answers  

---

Is primary key is clustered index?

0 Answers  

---

What is the full form of sql?

0 Answers  

---