1 votes 1 votes Name the SQL aggregation operator which does not ignore NULL. COUNT MAX AVG SUM Databases sql databases revision + – Arjun asked Jan 20, 2016 retagged Mar 9, 2019 by Abdul Wazeed Arjun 539 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes Count Count(*) will give count of all rows(including null) Pooja Palod answered Jan 20, 2016 Pooja Palod comment Share Follow See all 3 Comments See all 3 3 Comments reply Shashank Chavan commented Jan 26, 2016 reply Follow Share but count ignores null when a specific column contains null values right? lets say rno name marks 1 shas 99 2 pqrs null 3 xyz 98 now if we apply, count(marks) it returns 2 0 votes 0 votes Shashank Chavan commented Jan 26, 2016 reply Follow Share http://www.w3schools.com/sql/sql_func_count.asp 0 votes 0 votes kapilbk1996 commented Aug 20, 2017 reply Follow Share https://stackoverflow.com/questions/40679208/count-includes-null-values This might help you 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes Option a is right. abhishekmehta4u answered Mar 9, 2019 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.