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

Do you know what are the ways available in sql server to execute sql statements?

1010

---

Explain how dts is used to extract, transform and consolidate data?

982

---

What is role playing dimension with two examples? : sql server analysis services, ssas

985

---

Is sql server a database?

961

---

What is difference between clustered and non clustered index?

970

---

What are the limitations/drawbacks or ssrs 2008 r2?

139

---

Why are sql functions used?

1102

---

What gets stored inside msdb database?

1233

---

What is the federation in sql azure?

95

---

Why use sub query in sql server and list out types of sub queries?

980

---

What are orphan records?

919

---

What is a system database and what is a user database?

1068

---

What is sqlcmd?

1025

---

What are the new security features added in sql server 2012? : sql server security

1003

---

What are advantages of ssrs or why we should use ssrs?

137

---