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 convert a string to a date in oracle database?

0 Answers  

---

What are the limitations oracle database 10g xe?

0 Answers  

---

what is the use of system.effective.date variable in oracle?

0 Answers  

---

What is oracle data type?

0 Answers  

---

Can we create trigger on materialized view in oracle?

0 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---

How to view the tablespaces in the current database?

0 Answers  

---

What is an Oracle sequence?

1 Answers  

---

What is a cursor variable?

0 Answers  

---

State any two functions of oracle?

0 Answers   Aricent,

---