mysql - (My)SQL: If subquery is not an empty set, return subquery

Question

This question is directed specifically toward MySQL, but I'm trying to ask it in such a way that standard SQL is applicable.

Context: I am trying to determine an end date in the following way: if there exists another start date after the entered start date, use the existing start date as the end date; otherwise, the end date should be 30 days after the entered start date.

The solution I've tried is similar to the following:

SELECT
  IF(
    EXISTS(  
      SELECT
        DISTINCT start_date
      FROM table
      WHERE ? < start_date AND
            identifier = ?
      ORDER BY start_date
      LIMIT 1
    ), (
    SELECT
      DISTINCT start_date
    FROM table
    WHERE ? < start_date AND
          identifier = ?
    ORDER BY start_date
    LIMIT 1),
    DATE_ADD(?, INTERVAL 30 DAY)
  ) AS end_date

My solution works, but I was hoping there were a more elegant, non-repetitive solution.

The generic solution would be one which—if a subquery exists—returns the values from the subquery; otherwise, something else can be returned.

Answer 1

Instead of a subquery do a left join (to the table itself)

SELECT
COALESCE(t2.start_date, t1.start_date)
FROM table t1
LEFT JOIN table t2 ON t1.identifier = t2.identifier AND t1.start_date > t2.start_date

The left joined entry is either there or it is not, which means it is not null or null. The COALESCE() function returns the first of its arguments which is not null.