Answer Posted / nag

create table MMM(Name varchar(20),age int)
select * from MMM
insert into MMM values('MIKE',20)

insert into MMM values('Shuck',30)

insert into MMM values('Shuck',30)

insert into MMM values('Sh',90)
insert into MMM values('Shuc',60)
insert into MMM values('Sonu',70)
insert into MMM values('Siddu',80)
insert into MMM values('nagu',50)

SELECT name,age
FROM mmm
GROUP BY name,age
HAVING count(*) <=1

Try this query friends it will work out

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1118

---

What is primary key, unique key, and foreign key?

965

---

What is query processing?

929

---

What the class forname () does?

1051

---

Does the order of columns in update statements matter?

909

---

What is data source in connection string?

900

---

How to convert numeric expression data types by assignment operations?

1060

---

What is lock escalation? : sql server database administration

1146

---

Difference between report and query parameter.

1084

---

How to assign new column names in a view?

909

---

What are views used for?

1009

---

What is the difference between a fill factor of 100 and 0?

976

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

963

---

How to display a past time in days, hours and minutes?

1010

---

What is the difference between push and pull subscription? : sql server replication

1207

---