December 10, 2014
Distinct, AVG , COUNT how all behaves if null value exist in table
These are all basics but when asked in interview we make mistake.
select * from #temp
select AVG(id) from #temp [5/3 or 5/5]
select...
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.