Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
CEP : Filter similar data

900697
Member Posts: 50
Hi,
I don't want to report duplicate records as putput of CEP even though CEP source output duplicate records.
How to filter duplicate records along with WHERE conditions in CQL.
The Query:
Select id,time,location from channel
where id = "1786-568"
If inputs are:
1786-568,1:20,USA
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA
Output should be like:
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA
Please help.
Thanks,
Sri
I don't want to report duplicate records as putput of CEP even though CEP source output duplicate records.
How to filter duplicate records along with WHERE conditions in CQL.
The Query:
Select id,time,location from channel
where id = "1786-568"
If inputs are:
1786-568,1:20,USA
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA
Output should be like:
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA
Please help.
Thanks,
Sri
Answers
-
You can use 'distinct' keyword in SELECT list of your CQL query.
http://docs.oracle.com/cd/E23943_01/apirefs.1111/e12048/cqlstatements.htm#CQLLR1399 -
Thanks.
I used the group by class in CQL Query. Its also working fine.
Regards,
Sri
This discussion has been closed.