Skip to content

Tag: sql

Try to define a left join only with where condition

I try to find a particular SQL statement to replace an old SQL query. To summarize, I try to make a left join only with where conditions. Here is my test environment: I fill the tables with some data: The usual way for a left join is this: This query returns 1266 rows. But in the old application, which I

Unexpected token “” was found following “”

Im a newbie to DB2. Im trying to convert this sp from Microsoft SQL server to DB2 Here is the sp from Microsoft SQL: and this is the sp after i converted to DB2 Then i got this error: An unexpected token “” was found following “”. Expected tokens may include: “”.. SQLCODE=-…

SQL:pivot: convert each row into many rows depends on a condition

I have been trying to solve this but could not figure it out. so this is the table and more columns could be added: So if the value is one then I will display it in a different row but with the value being the column header itself My boss suggested using pivot to solve this but I am open

How to reverse this json

I have a problem about array reversing. I tried array_reverse(…,true) But it is not working. May be the place that i applied is wrong. So i already attached my php code and json result below. Plz help me to reverse this json. This is resultant json. What i want is, i want to reverse this. After reversio…