WHERE (ISNULL(columnName,0) > 0) vs WHERE (columnName IS NOT NULL) AND (columnName > 0)

Question

SELECT * FROM tableName WHERE (ISNULL(columnName,0) > 0) OR SELECT * FROM tableName WHERE (columnName IS NOT NULL) AND (columnName > 0) which one is better? columnName has int datatype JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You don't need to check for null values in your query so I guess this would be better. SELECT * FROM tableName WHERE columnName > 0