Interested to Buy Any Domain ? << Click Here >> for more details...
how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 7281 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Is truncate a dml command?
How do you create an execution plan?
In how many ways you can invoke ssrs reports?
What is format parameter in ssrs?
How to run sql server 2005 books online on your local system?
what is bit datatype? : Sql server database administration
Explain the difference between control flow and data flow?
What are commit and rollback in sql?
What stored by the model? : sql server database administration
Why is the need for data conversion transformations?
what stored procedure can you use to display the current processes? : Sql server administration
What is difference between index and primary key?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is the purpose of optimization?
