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
- 7413 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
Explain where clause?
How to use union to merge outputs from two queries together in ms sql server?
What are horizontal and vertical scaling?
How to generate create function script on an existing function?
How do indexes help, types?
How to select all columns of all rows from a table with a select statement in ms sql server?
If a stored procedure is taking a table data type, how it looks?
Why and when do stored procedure recompile?
Please explain go command in sql server?
How to resolve the orphan use problem? : sql server security
what are cursors? : Sql server database administration
explain different types of joins? : Sql server database administration
When would you prefer to have a minimum number of indexes?
What triggers long term care?
What is SQL Azure Federations?
