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

what is the system function to get the current user's user id? : Sql server database administration

1025

---

What part does database design plays a role in performance of an sql server-based application?

985

---

What is data file in computer?

947

---

Which are ddl commands?

1047

---

Please explain go command in sql server?

1057

---

How many database files are there in sql server 2000?what are they?

1053

---

What happens when the SQL Azure database reaches Max Size?

111

---

What is the use of keyword with encryption. Create a store procedure with encryption?

960

---

What is the difference between mysql and sql server?

1025

---

What is the optimization being performed in oracle and SQL Server?

1051

---

What are the different subsets of sql?

1551

---

How to check table values in sql server?

956

---

Describe the left outer join & right outer join. : sql server database administration

996

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1092

---

What are the steps to insert a table?

945

---