Select Where Please sign up for the course before starting the lesson. Nishtha Jain says: 12/18/2020 at 1:46 AM Hi, When I am writing a query as “Select * from from dbo.trade_data_hist where quantity = 0” , the data is not showing as 0 in quantity instead it is coming as blank in that cell. So, is there any issue with my data? Log in to Reply Nishtha Jain says: 12/18/2020 at 1:47 AM Query as “Select * from dbo.trade_data_hist where quantity = 0” Log in to Reply Mark Ross says: 12/21/2020 at 6:50 PM It might be if you passed in the data as a different data type it might recognize 0 as “”. Strange, but I’ve seen stranger things in SQL. Log in to Reply
Hi,
When I am writing a query as “Select * from from dbo.trade_data_hist where quantity = 0” , the data is not showing as 0 in quantity instead it is coming as blank in that cell. So, is there any issue with my data?
Query as “Select * from dbo.trade_data_hist where quantity = 0”
It might be if you passed in the data as a different data type it might recognize 0 as “”. Strange, but I’ve seen stranger things in SQL.