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;

Define views.

0 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

List the advantages of using stored procedures?

0 Answers  

---

Explain the commands in sql server?

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

What is co-related sub query?

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---