display related data even if the needed data is 0

Question

hello...

how do i display related data if the data i needed result is 0.

i have the above Sql and the result are as shown but sometime there are result that doesn't exist but i want to display 0 at the count7 column with related where condition such as ans_ss_id, ans_term and so on as above result.. how do i do that..please someone help me..tq in advance

Amit Gupta · Answer

You can use ISNULL function if value is null it display 0 ISNULL(columnName 0) For further reference: http://stackoverflow.com/questions/16667148/instead-of-null-how-do-i-show-0-in-result-with-select-statement-sql Do let me know if it solves your problem.

Bikesh Srivastava · Answer

Use this code. ISNULL(clmnName 0)