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 types of trigger in oracle?

0 Answers  

---

What is a data dictionary and how can it be created?

0 Answers  

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---

Explain oracle instance.

0 Answers  

---

which is the best training centre for learning oracle?

13 Answers  

---

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

How do you bind variables in oracle?

0 Answers  

---

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

0 Answers  

---

How to grant create session privilege to a user in oracle?

0 Answers  

---

What are the data types in oracle?

0 Answers  

---

What are inner join and outer join?

3 Answers  

---