Answer Posted / sahil

The query will be to get the total of salary >= 5000 in a
department is :


select deptname, sum (salary) as totalsalary from Department
group by deptname

then it will shown like

deptname total salary
a 4000
b 5000
c 9000

now we will get the highest total salary from department
remember group by is always used to group-set.

select deptname, sum (salary) from Department
group by deptname
having sum (salary) >= 5000

Then you will get the answer!!

What is full outer join in sql server joins?

1139

---

How to test a dml trigger in ms sql server?

1114

---

Explain indexed views?

1028

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1249

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2811

---

Can a database be shrunk to 0 bytes, if not, why?

1162

---

How to define output parameters in stored procedures?

1082

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1049

---

Do you know the cursor types?

1205

---

Explain Reporting Life Cycle?

132

---

How do you run a trace?

946

---

explain how to create a new schema in a database? : Sql server database administration

1156

---

Can we update data in a view?

1080

---

What are the steps you should follow to start sql server in single-user mode?

951

---

How to deploy the Report?

140

---