Answer / aaa

Group by clause

Answer / chandana

Select avg(sal) from Emp
where avg(sal) >1000;

This gives an error. So, Group Functions(Aggregate) should
not be used in the Where Clause

Answer / manikanta

WE can use group by clause in where clause.
For Ex: SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

We can't use case statement in where clause.

what is the syntax of DROP command?

10 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

How to download oracle database 10g xe?

0 Answers  

---

How to convert dates to characters in oracle?

0 Answers  

---

What happens to the current transaction if the session is killed?

0 Answers  

---

what is the difference between table and veiw?

4 Answers   IBM,

---

how to join query for one source type is oracle another source type is sql server ?

0 Answers   iGate,

---

how to store only time in a data base table

2 Answers  

---

What is a parameter file in oracle?

0 Answers  

---

What is oracle database 10g express edition?

0 Answers  

---

What is MTTR advisor in Oracle?

0 Answers   MCN Solutions,

---

How do you find current date and time in oracle?

0 Answers  

---