Distinct on more than one column

I cannot get the distinct values of just one column using. Would we have more than minutes of light, if the sun went out? The above result shows the same agent_code, ord_amount and cust_code appears more than once in theorders table.

You can select distinct for more than one column , however, the distinct refers to all the columns in the select list. In your example, if you leave out the parens, it should work fine. If you need to select distinct values of only some columns, then you need to concatenate them as Brad suggested.

Is there a way to get distinct values for multiple columns? So rather than every ThreadI just one distinct instance of each value. Rate this: Please or sign in to vote.

Then at the end you put the distinct column to filter and you only group it with that last distinct column. DISTINCT for only one Column. It could be two, or 1 or even just one column. The distinctness applies to the columns in the GROUP BY. Every result row will be completely distinct in those two columns.

If you wanted distinct rows by those two columns, but with additional columns as well, then the question was indeed not as simple as it first appeared. Extract unique values from multiple columns with array formula. Sometimes, you need to extract the unique values from a single column , the above methods will not help you,. More than 3powerful features. I can do a count distinct on one column, but not on two columns.

Count Distinct on more than one column ? I assume the keys are integers, so maybe something like this? Obviously there are a lot more columns. About Us Learn more about Stack Overflow the company. How to select distinct for one column and any in another column ? I need to query an SQL database to find all distinct values of one column and I need an arbitrary value from another column.

For example, consider the following table with. Please read the syntax and significance of the Agreegate. Just please use a union and more select. Only advantage (if it is), one single scan from main table.

Select all columns from table but apply function to column. We can count during aggregation using GROUP BY to make distinct when needed after the select statement to show the data with counts. Basically I am wanting to be distinct on one row, but view different rows. You can not do this with result set, if scientificname can have more than CommonName.

For each provider in column I would like to get a distinct count of other columns (age groups ) based on the customer column. Below are some of the columns of the report. Ok I could use a temporary table but my select distinct tends to.

How can I write this query without using the pipe? Ask Question Asked years, month ago. Active years, months ago.