How to set a default row for a query that returns no rows?

by

One approach for Oracle:

SELECT val
FROM myTable
UNION ALL
SELECT 'DEFAULT'
FROM dual
WHERE NOT EXISTS (SELECT * FROM myTable)

Or alternatively in Oracle:

SELECT NVL(MIN(val), 'DEFAULT')
FROM myTable

Or alternatively in SqlServer:

SELECT ISNULL(MIN(val), 'DEFAULT')
FROM myTable

These use the fact that MIN() returns NULL when there are no rows.

More Related Contents:

  1. Get previous month in SQL when given a varchar
  2. How to retrieve a specific users’ data from SQL Server?
  3. What is wrong with this multi-criteria WHERE statement?
  4. ListAGG in SQLSERVER
  5. DateTime2 vs DateTime in SQL Server
  6. How to generate a range of numbers between two numbers?
  7. T-SQL dynamic pivot
  8. Generate Dates between date ranges
  9. Select group of rows that match all items in a list
  10. Is there any difference between IS NULL and =NULL
  11. How to print VARCHAR(MAX) using Print Statement?
  12. SQL statement to select all rows from previous day
  13. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  14. How would you implement sequences in Microsoft SQL Server?
  15. What does =* mean?
  16. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  17. How can I combine multiple rows into a comma-delimited list in SQL Server 2005?
  18. SQL Select Upcoming Birthdays
  19. SQL : in clause in stored procedure:how to pass values
  20. How can I include null values in a MIN or MAX?
  21. Favourite performance tuning tricks [closed]
  22. Best way to do nested case statement logic in SQL Server
  23. Query a database based on result of query from another database
  24. How to delete the top 1000 rows from a table using Sql Server 2008?
  25. CHECK CONSTRAINT on multiple columns
  26. SQL count consecutive days
  27. is it possible to select EXISTS directly as a bit?
  28. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  29. Use one CTE many times
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment