Aug 30, 2005 #1 rrrkrishnan Programmer Joined Jan 9, 2003 Messages 107 Location US Are nulls ignored by aggregate functions like count(columnname), max, min... in all versions of Oracle older and newer. Thanks.
Are nulls ignored by aggregate functions like count(columnname), max, min... in all versions of Oracle older and newer. Thanks.
Aug 30, 2005 1 #2 SantaMufasa Technical User Joined Jul 17, 2003 Messages 12,588 Location US Yes, by design. Mufasa (aka Dave of Sandy, Utah, USA) [http://www.dasages.com: Providing low-cost remote Database Admin services] Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA. Upvote 0 Downvote
Yes, by design. Mufasa (aka Dave of Sandy, Utah, USA) [http://www.dasages.com: Providing low-cost remote Database Admin services] Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.