Answer Posted / jaleel ahamed s

create table emp (empid int,empname varchar)

insert into emp values (101,'a')
insert into emp values (102,'b')
insert into emp values (103,'a')
insert into emp values (104,'c')
insert into emp values (105,'a')

select * from emp

SELECT EmpName,Count(EmpID)Cnt From Emp Group By EmpName
Having Count(EmpName) > 1

How we create SQL Server 2005 Reporting Services ? Give me Sample

1982

---

What is join and name different type of joins?

1041

---

How to end a stored procedure properly in ms sql server?

1078

---

What is an sql server agent?

1056

---

What are the advantages of partitioning?

1098

---

How can we remove orphan records from a table?

978

---

How will you optimize a stored procedure optimization?

1028

---

What are the five characteristics of good data?

909

---

Explain can SSRS reports Cache results?

158

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1071

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1027

---

What are number line correlation administrators will use while working with a subquery?

1167

---

What is table value parameters (tvp)?

1092

---

How to make a remote connection in a database?

969

---

Why use view instead of a table?

940

---