Loading

display related data even if the needed data is 0

Hazel Mahmud

10y998SQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Use this code.
ISNULL(clmnName, 0)
Amit Gupta10y ago
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.