Answer Posted / asit

Can someone answer to this. on below query where i want to find same salary in employee table,

SELECT * FROM EMPLOYEE WHERE (SAL IN (SELECT sal FROM empLOYEE GROUP BY sal HAVING COUNT(sal) > 1))

i am getting correct output.

but if i change it to 'COUNT(SAL)>=1' then it prints all the lines from the table.

can you implement data mining in SSRS?

157

---

How to insert a new row into a table with "insert into" statements in ms sql server?

1016

---

Why are views required in the sql server or in any other database?

1004

---

What is thr feature of change data capture?

1039

---

how can you check the level of fragmentation on a table? : Sql server administration

1041

---

What is Lock table in SQL?

1523

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1281

---

what is blocking? : Sql server database administration

1092

---

What is Dependency Injection and provide example?

1182

---

Difference between drill down and drill through report.

1009

---

how would you store your query in an SSRS report or a Database server?

167

---

What is normalization? Describe its different types.

1157

---

Can you explain what is sql server english query?

1058

---

What do you understand by user-defined function in the sql server?

1013

---

Explain unique key in sql server?

1051

---