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 to use order by with union operators in ms sql server?

964

---

What is the security model used in sql server 2005?

932

---

Define self join?

984

---

What is sql server replication? : sql server replication

920

---

What is temporal table?

818

---

how would you improve etl (extract, transform, load) throughput?

968

---

What is 2nf normalization?

964

---

What is normalization according to you and explain its different levels?

894

---

What is the difference between clustered index and primary key?

867

---

What is an inner join?

909

---

What is rtm version in sql server?

974

---

Why use identity in sql server?

1005

---

What is difference between order by and group by?

951

---

How to create function without parameter in sql server?

988

---

whats the maximum size of view state??

2146

---