Answer / anjaligarg

First we declare is as primary key and after group by we can get uniqu values.

CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (ID)
);

SELECT ID, LastName,FirstName
FROM Persons
GROUP BY ID, LastName,FirstName;

What’s the use of custom fields in report?

1 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1 Answers  

---

What are “lost updates”?

1 Answers  

---

What is an entity-relationship diagram (erd)?

1 Answers  

---

Explain different types of locks in sql server.

1 Answers  

---

How will you go about resolving deadlocks?

1 Answers  

---

How to create new tables with "select ... Into" statements in ms sql server?

1 Answers  

---

What are the different types of backups avaialabe in sql server 2005?

1 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

1 Answers   TCL, Wipro,

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1 Answers  

---

What is sql server programming?

1 Answers  

---