你即將離開本站

並前往https://www.sqlservercentral.com/forums/topic/how-to-return-null-or-value-when-nothing-is-returned-from-query

How to return Null or value when nothing is returned from Query

I have a simple query: SELECT name FROM atable WHERE a = 1. I want it to return Null if it finds nothing, but it just returns an empty set.

確定！ 回上一頁

查詢 「MySQL if empty」的人也找了：

  1. MySQL is not NULL or empty
    2.
  2. Mysql case when null
    3.
  3. Mysql empty value
    4.
  4. MySQL NULLIF
    5.
  5. SQL ISNULL or empty
    6.
  6. MySQL WHERE IS NOT NULL
    7.
  7. Mysql WHERE IF NULL
    8.
  8. SQL check if query result is empty
    9.