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.

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

What are triggers in oracle?

0 Answers  

---

How do I recompile a procedure in oracle?

0 Answers  

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

0 Answers  

---

How to shutdown your 10g xe server?

0 Answers  

---

What is Virtual Private Database in Oracle?

0 Answers   MCN Solutions,

---

How to export your connection information to a file?

0 Answers  

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

What do you mean by cdb and pdb in oracle 12c?

0 Answers  

---

What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,

---

What are the types of trigger in oracle?

0 Answers  

---