Solved... select * from tabName where deleteDate is NULL; My bad..
On Thursday, 27 March 2014 11:58 AM, Rishabh Bhardwaj <[email protected]> wrote: Hi all, I have a table 'tabname' which has a field 'deleteDate' with type BIGINT.There are records with NULL value in this field.I want to retrieve all those records. But when I execute Query, select * from tabName where deleteDate<>NULL; I don't get any record in the result set. What is wrong in this query and what should it be to serve the purpose? Help! Thanks, Rishabh.
