Answer Posted / 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 do you mean by an execution plan? How would you view it?

871

---

Can you tell me about the concept of ER diagrams?

1018

---

Do you know data definition language, data control language and data manipulation language?

987

---

What is partition index in sql server?

1049

---

What is the server name in sql server?

959

---

What are different types of collation sensitivity?

943

---

What stored by the model? : sql server database administration

903

---

What will happen if a column containing char type data is changed to the nchar data type?

1044

---

What is the difference between the 2 operating modes of database mirroring?

1059

---

Explain the phases a transaction has to undergo?

987

---

What are the character string functions supported by sql server 2005?

936

---

How do I find information about the install locations for the various instances running on a computer?

1033

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

---

What is difference between line feed ( ) and carriage return ( )?

855

---

Why do we use trigger?

917

---