Answer Posted / shashank shrivastava

Table-admin
------------------
adminID adminName
1 admin
2 tester
3 admin

SQL:
---------------
DELETE admin.* FROM admin,
(SELECT count(adminName) as c, MAX(adminID) as m from
admin GROUP BY adminName HAVING c>1) as new_admin
WHERE admin.adminID=new_admin.m

What is the difference between ddl and dml?

1005

---

How to delete multiple rows with one delete statement in ms sql server?

942

---

How to loop through result set objects using mssql_fetch_array()?

1021

---

Can you explain full-text query in sql server?

972

---

Do you know what are acid properties?

1018

---

Define model database?

935

---

What encryption security is available in sql azure?

99

---

Which are the two editions in which SQL Azure database available?

117

---

Why do we need different type of parameter?

999

---

how many no of arguments can be passed in procedures and functions

5466

---

Why is sql server log file full?

979

---

How to convert binary strings into integers in ms sql server?

963

---

What is the sql case statement used for? Explain with an example?

941

---

What is transactional replication?

907

---

Explain how to maintain a fill factor in existing indexes?

929

---