Hany Helmy (2/1/2015)
Maybe tomorrow QoTD will be:
COUNT(*) AS MyCount
And MyCount value will be 2 in this case (*) for the Null rows 😛
Or, using field "Mychar" in the aggregate function instead of MyId
To Author: Thank you for the post, really good one and I liked the twist of logic happening in my head. 😎
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.