Relative Content

Tag Archive for postgresql

Find count of rows having a text on multiple columns. Need an alias row to display

I have a table with multiple columns.’Product Name’ being one. Table has records for multiple products. product name is also used in a free text field. I need reports on how many rows have a particular product listed in ‘Product Name’or in ‘Free text’ fields.
Table as below :
Product Name | Issue description |
Microsoft | outlook not working
Lenovo | laptop blue screen
Samsung | microsoft word issu

Find count of rows having a text on multiple columns. Need an alias row to display

I have a table with multiple columns.’Product Name’ being one. Table has records for multiple products. product name is also used in a free text field. I need reports on how many rows have a particular product listed in ‘Product Name’or in ‘Free text’ fields.
Table as below :
Product Name | Issue description |
Microsoft | outlook not working
Lenovo | laptop blue screen
Samsung | microsoft word issu