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 recycle bin in Oracle?

0 Answers   MCN Solutions,

---

Can Multiple instances be run on Single Machine???

3 Answers  

---

what is the difference between oracle enterprise edition and oracle express edition?

2 Answers  

---

find out the second highest salary?

55 Answers   Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

How to get the Installed Oracle Version Information ?

0 Answers   MCN Solutions,

---

what are the advantages of running a database in archive log mode?

0 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

---

What is a nvl function? How can it be used?

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

How to write text literals in oracle?

0 Answers  

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---