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

How to create user defined functions with parameters?

1296

---

Define full outer join in sql server joins?

1050

---

What is the web service used for reporting services?

126

---

How to view existing indexes on an given table using sys.indexes?

1150

---

Give an example of why you would want to denormalize a database

1028

---

Write a query for primary key constraint with identity key word?

1080

---

How to remove duplicate rows from table?

1311

---

What is right outer join in sql server joins?

1216

---

What is database replication? What are the different types of replication you can set up in sql server?

1017

---

mention different types of relationships in the dbms?

1087

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1071

---

What is a join in sql?

1155

---

How to list all field names in the result set using mssql_field_name()?

951

---

What do you understand by check constraint in sql server?

1015

---

Can you create a logon trigger in sql server 2005 express edition?

1119

---