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.

Explain the family trees and connection by clause

0 Answers  

---

Does a Before form trigger fire when the parameter form is suppressed ?

1 Answers   Oracle,

---

What is a recycle bin in oracle?

1 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,

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

---

Is there an oracle sql query that aggregates multiple rows into one row?

0 Answers  

---

Explain rename?

0 Answers  

---

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

0 Answers  

---