You can distinct values of any field using the below code: //get distinct field values list<AggregateResult > ma = [select tag__c, COUNT (id) FROM Download_LineItem__c GROUP BY tag__c]; set<string> se = new set<String> (); for (AggregateResult m: ma) { se.add ((string)m.get ('tag__c')); } system.debug ('se``` '+se); Share
Full Answer
How to count the number of distinct values in a soql?
You can use SOQL COUNT_DISTINCT () keyword. This will just count how many of your items values are distinct. This keyword is part of Aggregate functions. Show activity on this post. Thanks for contributing an answer to Salesforce Stack Exchange!
Is SELECT DISTINCT justified for interfacing data?
However, with regards to interfacing data, lots of times it is not lookups, just raw; therefore the Select Distinct is justified. You need to sign in to do that.
How to get distinct record of a key?
So you will have the distinct record. Just using yourmap.get('your_key'). to get result Share Improve this answer Follow answered Mar 2, 2018 at 8:11 Dung RieuDung Rieu 2933 bronze badges Add a comment | Your Answer Thanks for contributing an answer to Stack Overflow!
Does soql support the DISTINCT keyword?
SOQL, which is used to query Force.com objects, does not support the DISTINCT keyword. You can get to the same place by separating out the data you want to be unique, creating an object with the non-repeating data in a field designated unique, and then doing a lookup to the related object.
How do I find unique values in Salesforce?
See how many distinct values a column in your report returns with a unique count....Duplicate values aren't counted.While editing a report in the report builder, find the column for which you want to count unique values.Click. | Show Unique Count.Click Save.
How do I select distinct values in SOQL?
SELECT count(Id), Name FROM Participant__c GROUP BY Name To access the unique names in Apex, you could do something like this or simply use sets.
How do I use alias in SOQL query?
You can use alias notation in SELECT queries. To establish the alias, first identify the object, in this example a contact, and then specify the alias, in this case “c.” For the rest of the SELECT statement, you can use the alias in place of the object or field name.
What is select distinct in SQL?
The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
How do I export a query result from Salesforce Developer Console?
Right-click on the query result and select Inspect.Look for the table tag, then do "Copy element".Open Excel and Paste to get the result.
How do I use GROUP BY in Salesforce?
You can use the GROUP BY option in a SOQL query to avoid iterating through individual query results. That is, you specify a group of records instead of processing many individual records. fieldGroupByList specifies a list of one or more fields, separated by commas, that you want to group by.
How do I compare two field values in SOQL?
Salesforce does not allow direct field to field comparison in SOQL query. To achieve this you can create a formula field that will compare fields and return a value (such as true or false) which you can use in a WHERE clause.
How do I query Sobject in Salesforce?
If you have the sobject name in a string, e,g, 'sobjname', you can then query back the record via something like: String queryStr='select id from ' + sobjname; List
What is SOSL and SOQL in Salesforce?
A SOQL query is the equivalent of a SELECT SQL statement and searches the org database. SOSL is a programmatic way of performing a text-based search against the search index. Whether you use SOQL or SOSL depends on whether you know which objects or fields you want to search, plus other considerations.
How can I get distinct values of all columns in SQL?
MySQL – Distinct Values To get unique or distinct values of a column in MySQL Table, use the following SQL Query. SELECT DISTINCT(column_name) FROM your_table_name; You can select distinct values for one or more columns. The column names has to be separated with comma.
How do you find unique records?
In Excel, there are several ways to filter for unique values—or remove duplicate values:To filter for unique values, click Data > Sort & Filter > Advanced.To remove duplicate values, click Data > Data Tools > Remove Duplicates.More items...
How do I SELECT distinct one column?
Adding the DISTINCT keyword to a SELECT query causes it to return only unique values for the specified column list so that duplicate rows are removed from the result set.