How To apply Semimerge Row in Postgres sql?

1

I am try to find out my result but I am unable to find please help. I am attaching problem image .In this image I gave what actually is problem.

PROBLEM.PNG1337×1440 25.3 KB

2

You might want to post to a PostgreSQL forum. This is primarily SQL Server