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

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

---

What is a dbms wizard?

1074

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1052

---

Why would you call update statistics?

1076

---

Difference between Logical Page and Physical Page in SSRS.

491

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

What you can do to delete a table without the delete trigger firing?

1013

---

What options are available to audit login activity? : sql server security

1202

---

What is query processing?

990

---

Determine when to use stored procedure to complete sql server tasks?

1115

---

What will be the maximum number of index per table?

1058

---

How to select some specific rows from a table in ms sql server?

1058

---

What are the different index configurations a table can have?

1011

---

Explain features of analysis services?

1082

---

What stored procedure would you use to view lock information?

1019

---