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 are the attributes of cursor?

0 Answers  

---

How to delete multiple rows from a table in oracle?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

---

What is a read write transaction in oracle?

0 Answers  

---

What is the difference between substr & instr functions?

0 Answers  

---

What is format trigger?

0 Answers  

---

What is a dead lock in oracle?

0 Answers  

---

What is backup in Oracle?

0 Answers   MCN Solutions,

---

What do you understand by a database object?

0 Answers  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

What is the simplest tool to run commands on oracle servers?

0 Answers  

---

What is Trace File ?

4 Answers   Thermotech,

---