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 schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,

---

What do you mean by a tablespace?

0 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

Is truncate autocommit in oracle?

0 Answers  

---

What is a Segment ?

1 Answers  

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

Explain the use of analyse option in exp command.

0 Answers  

---

What are operators in oracle?

0 Answers  

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

What is set verify off in oracle?

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

How to write a query with a left outer join in oracle?

0 Answers  

---