How to add a user defined column with a single value to a SQL query September 18, 2023 by Tarik Like this: SELECT PRODUCT_ID, ORDER_QUANTITY, 999 as USER_VALUE FROM PRODUCT_TABLE GROUP BY SALES_DAY