how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 6890 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
Why do we partition data?
How to use order by with union operators in ms sql server?
Do you know what are various aggregate functions that are available?
Does order by actually change the order of the data in the tables or does it just change the output?
What is database isolation in sql server? : sql server database administration
what is a live lock? : Sql server database administration
What is t-sql script to take database offline – take database online.
What does it mean to invest in the index?
What is difference between createstatement and preparedstatement?
List out different types of normalizations in sql server and explain each of them?
What is the difference between join and inner join?
How to download and install microsoft sql server management studio express?
What is the purpose of self join?
Which table keeps information about stored procedures?
What do you understand by mirroring and mention the advantages of the mirroring?
