Answer Posted / uma

The SELECT DISTINCT Statement
The DISTINCT keyword is used to return only distinct
(different) values.
The SELECT statement returns information from table columns.
But what if we only want to select distinct elements?
With SQL, all we need to do is to add a DISTINCT keyword to
the SELECT statement:

Syntax
SELECT DISTINCT column_name(s)
FROM table_name

Using the DISTINCT keyword To select ALL values from the
column named "Company" we use a SELECT statement like this:
SELECT Company FROM Orders
"Orders" table

Company OrderNumber
Sega 3412
W3Schools 2312
Trio 4678
W3Schools 6798
Result

Company
Sega
W3Schools
Trio
W3Schools
Note that "W3Schools" is listed twice in the result-set.
To select only DIFFERENT values from the column named
"Company" we use a SELECT DISTINCT statement like this:
SELECT DISTINCT Company FROM Orders

Result:
Company
Sega
W3Schools
Trio
Now "W3Schools" is listed only once in the result-set.

What is the difference between delete and truncate statements?

1127

---

What does sql server mean?

1164

---

What is the fillfactor concept in indexes?

1035

---

what are the different ways to return the rowcount of a table?

1050

---

What happens when the SQL Azure database reaches Max Size?

113

---

How to recover from sql injection? : sql server security

1067

---

What is raiseerror? What is raiseerror?

1193

---

What is tablesample?

1176

---

Which table keeps information about stored procedures?

983

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1049

---

Will the writetext statement activate a trigger?

1154

---

Can sub report data source be different from that of the parent report?

149

---

What is clustered primary key?

1082

---

Name few of the dcl commands in sql?

1054

---

How many ways to create table-valued functions?

1056

---