Returns nothing. why?

Data Science, AI and ML
,
#1

select Order_Quantity from market_fact where ‘Cust_id’ = ‘Cust_839’

this is the query i ran in my sql workbench. It gives no error. Also returns nothing but the column name i.e “Order_Quantity”. But in the table “Market_fact” I can see that there is some value in Order_Quantity column where customerID is Cust_839. I want to know why does it not return any value.

#2

Hi Nitish,

Can you also check whether values in “cust_id” in capital letter or small cal letter. because data in sql tables are case sensitive.

If query doesn’t returning you anything it means that condition not satisfy with any data. So you can check the input argument data.

Thanks!!