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 can you merge two tables in oracle?

0 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

How to create an oracle testing table?

0 Answers  

---

What is the difference between a primary key & a unique key?

0 Answers  

---

Can we use bind variables in oracle stored procedure?

0 Answers  

---

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

What is the difference between alert log file and trace file ?

1 Answers  

---

How to assign values to variables?

0 Answers  

---

Explain the use of analyse option in exp command.

0 Answers  

---

How to drop an index?

0 Answers  

---

How data locks are respected in oracle?

0 Answers  

---

What is instant client oracle?

0 Answers  

---