Answer / 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.

Answer / krishnamoorthy.n

select distinct * from <tablename>

How to provide values to user defined function parameters?

0 Answers  

---

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

What are different types of schemas?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---