Answer Posted / lalit pandey

SELECT field1,count(field1) "Number of Occurrence"
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;

What is the difference between Stored Procedures and triggers?

1135

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1105

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1446

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1147

---

What is the security principal at the server level that represents your session?

1063

---

Can we use where and having clause together?

1100

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2256

---

Explain features and concepts of analysis services?

1024

---

What is difference between index seek vs. Index scan?

1202

---

What is index fragmentation in ms sql server?

1148

---

What is function of ROLLUP ?

1145

---

What's new in sql management studio for sql server? : sql server management studio

1128

---

What is the default value of an integer data type in sql server 2005?

999

---

Explain active/passive and active/active cluster configurations?

1109

---

How to verify a login name with sqlcmd tool?

1267

---