<div>
<div class="content wysiwyg-content">
Hi, 
 
Im new to CB and I have the following documents that have these fields: (among others) 
&nbsp; &quot;_class&quot;: &quot;com.wrapper&quot;, 
&nbsp; &quot;dbProfile&quot;: { 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot;operatorId&quot;: &quot;3026&quot;, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;profileType&quot;: &quot;BEL_PR_LT&quot; 
} 
 
I have several combinations of the pair dbProfile.operatorId/dbProfile.profileType among the documents but all have the _class the same. 
 
I wanted to run a query that would display the all the possible combinations of dbProfile.operatorId/dbProfile.profileType only once (even if it appears more than once &nbsp;- DISTINCT in SQL). 
 
How would this look like in a CB query format? My bucket name is apoiu. 
 
Tks, 
J
</div>
</div>

Hi,

Im new to CB and I have the following documents that have these fields: (among others)
  "_class": "com.wrapper",
  "dbProfile": {
         "operatorId": "3026",
          "profileType": "BEL_PR_LT"
}

I have several combinations of the pair dbProfile.operatorId/dbProfile.profileType among the documents but all have the _class the same.

I wanted to run a query that would display the all the possible combinations of dbProfile.operatorId/dbProfile.profileType only once (even if it appears more than once  - DISTINCT in SQL).

How would this look like in a CB query format? My bucket name is apoiu.

Tks,
J

Couchbase Query - Display only one result for duplicated entries

A NoSQL database provides a mechanism for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include: simplicity of design, simpler "horizontal" scaling to clusters of machines and finer control over availability. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are specified from those used by default in relational databases, making some operations faster in NoSQL. Sometimes the data structures used by NoSQL databases are also viewed as "more flexible" than relational database tables.

NoSQL Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.