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>

What is the difference between count () and rowcount ()?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

what purpose does the model database serve? : Sql server database administration

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

---

What is checkpoint process in the sql server?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

Explain what are sparse columns?

0 Answers  

---

What is the need for group functions in sql?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---