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

Do you know what is xpath?

1154

---

How to insert data with null values?

1081

---

What is normalization? Explain its different types?

1152

---

What does the on delete cascade option do?

1062

---

How you can move data or databases between servers and databases in sql server?

1100

---

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

1217

---

What is onf in normalization form?

1111

---

What does ss stand for sexually?

1143

---

What is normalization 1nf 2nf 3nf?

1109

---

How do I start sql server agent automatically?

1027

---

Explain use of expression builder.

1069

---

What is index fragmentation in ms sql server?

1140

---

Why union all is faster than union?

977

---

Explain about Normalization?

1122

---

What is constraints and its types?

998

---