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 we delete a row using varray

3 Answers   CTC,

---

What is a SNAPSHOT ?

1 Answers  

---

How will you differentiate between varchar & varchar2?

0 Answers  

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

0 Answers  

---

Why cursor variables are easier to use than cursors?

0 Answers  

---

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

how to find out second largest value in the table

8 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

How to convert characters to dates in oracle?

0 Answers  

---

Does oracle partitioning improve performance?

0 Answers  

---

What is the purpose of a cluster?

1 Answers  

---