Skip to content
Advertisement

SQL returning 1 single column value on a multiple row

This is my query so far. But what I need is to return one single value of a column like this. enter image description here

But in my query so far, this is the returning output. enter image description here

This my query.

How can I get rid of the double values?

Advertisement

Answer

You can use analytical function as follows:

Let’s say the column you highlighted is sol.actual_delivered then use the following expression instead of sol.actual_delivered

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement