Answer Posted / kumar

sno names
1 arun
2 arun
3 arun
6 arun
7 bala
11 bala
12 guna
9 guna
14 guna
10 raj
13 raj

Table Name T1
Fields Names Sno,Names
Delete From t1 where sno not in
(select min(sno) from t1 group by names)

Define Wed Edition in SQL Azure?

100

---

what are user defined datatypes? : Sql server database administration

957

---

How to generate create table script on an existing table in ms sql server?

1138

---

How to use “drop” keyword in sql server and give an example?

1119

---

Define the one-to-one relationship while designing tables.

897

---

What is mean by candidate key?

1001

---

What do you know about system database? : SQL Server Architecture

972

---

What is cursor in ms sql server?

1136

---

What is database black box testing?

1024

---

How to insert stored procedure result into temporary table?

1010

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1007

---

How to receive returning result from a query?

1108

---

Why do we use trigger?

956

---

can an automatic recovery be initiated by a user? : Sql server administration

943

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1027

---