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

How to create a stored procedure with a statement block in ms sql server?

985

---

How to verify the port number of the sql server?

1035

---

What are the differences between having and where clause.

919

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

964

---

Explain alternate key, candidate key and composite key in sql server?

858

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

968

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1067

---

How to change parameter value inside the report?

153

---

Explain isolation levels that sql server supports?

985

---

Do I need a report server to run reports in my application?

153

---

what is the system function to get current user's user id? : Sql server database administration

945

---

Can an automatic recovery be initiated by a user?

941

---

How to make remote connection in database?

953

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6750

---

What is temporal data type?

868

---