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 does select 1 mean?

0 Answers  

---

Explain transaction server implicit?

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

What are sql server procedures?

0 Answers  

---

what is a cursor and what is its use?

2 Answers   L&T,

---

What sql server means?

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

How to insert multiple rows with a subquery?

0 Answers  

---

What is transaction server auto commit?

0 Answers  

---