Skip to Content
0
Aug 16, 2020 at 11:28 AM

Finding occurrence of a word in a database table using another Table

138 Views Last edit Aug 17, 2020 at 06:36 AM 2 rev

I want a open sql select query which can count the number of occurances of each word in the database table using another table

following is the scenario:

database Table1: t1

capture1.png

database table: t2

capture2.png

After query execution result should go in a internal table like shown

Internal table : Itab

capture3.png

Note : - The words column of T1 is of String format, so we cannot use it directly in where, order by, group by clause. It shows an error. So, Please provide a query keeping this in mind.

Attachments

capture1.png (5.7 kB)
capture2.png (2.9 kB)
capture3.png (4.2 kB)