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>

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

How to stop log file growing too big?

0 Answers  

---

How exceptions can be handled in sql server programming?

0 Answers  

---

Define magic tables in sql server?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

What is trigger in salesforce?

0 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

What are the different types of backups avaialabe in sql server 2005?

0 Answers  

---