Answer Posted / biswa

select *
from (select eno,dno,sal,avg(sal) over(partition by dno) as
avg_sal
from emp)
where sal<avg_sal;

OR

select e1.empno,e1.deptno,e1.sal
from emp e1
where sal>(select avg(sal) from emp e2
where e1.deptno=e2.deptno)

Why is the cursor important?

1083

---

How can I tell if sql is running?

1135

---

How does cross join work?

1010

---

what tools available for managing mysql server? : Sql dba

1134

---

What are the 3 types of behavioral triggers?

1319

---

What are the differences between implicit and explicit cursors?

1114

---

What is difference between nchar and nvarchar?

1104

---

Describe types of sql statements?

1108

---

what is a table in a database ? : Sql dba

1090

---

What is sql and how does it work?

1252

---

what are date and time data types? : Sql dba

1031

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1265

---

Explain architecture of sql server notification services?

1117

---

How to get list of all tables from a database?

1213

---

What is a temporal data type?

1114

---