Answer Posted / subbu

Query Output is :

SQL> select *from emp where sal=any( select sal from emp
group by sal having count(sal)>1);

EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- -------
--- ---------- ----------
7521 WARD SALESMAN 7698 22-FEB-81
1250 500 30
7654 MARTIN SALESMAN 7698 28-SEP-81
1250 1400 30
7788 SCOTT ANALYST 7566 19-APR-87
3000 20
7902 FORD ANALYST 7566 03-DEC-81
3000 20

What happens if null values are involved in datetime operations?

954

---

Explain difference between control flow and data flow?

943

---

What are three major types of constraints?

1094

---

How to stop a loop early with break statements in ms sql server?

995

---

explain different levels of normalization? : Sql server database administration

979

---

Why variables called the most powerful component of ssis?

1055

---

What is 1nf normalization form?

1015

---

What are the steps you will take to improve the performance of a poor performing query?

957

---

How to use old values to define new values in update statements in ms sql server?

1241

---

How to add additional conditions in SQL?

1004

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

980

---

List the different types of collation sensitivities in sql server?

1025

---

Tell me about normalization in DBMS.

980

---

Why do we need different type of parameter?

1036

---

Tell me what are the essential components of sql server service broker?

927

---