Well, that's pretty much the specs of SQL: You get one row of output for
each row in the table meeting the Where and Having criteria. If there are no
such rows, then you get zero rows of output. What if your table has two
rows? Are you expecting to get two rows of output or just one? Without
kn
Hi list,
I'm new here so I don't know if this has been discussed earlier.
I have a problem with the following:
SELECT IF(column = 'string', 'a', 'b') AS test FROM table;
It works just fine if the table is populated. However, if the table is empty
(which this one very well can be from time to t
