SQL Tutorial | How to Avoid a Divide By Zero Error in SQL | NULLIF

preview_player
Показать описание
In this SQL tutorial, we learn some techniques to avoid the Divide By Zero error in SQL.

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

IBM Data Science Professional Certificate

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Рекомендации по теме
Комментарии
Автор

Thanks I really need this help with sql server

babytigtig
Автор

Thank you for posting this video. Though it sounds simple, it is of great use for many folks.Keep posting the tricky SQL videos.

krishna
Автор

I use case statement in that condition

shami
Автор

Select Date_reported, SUM(New_cases) as Totalcases, SUM(cast(New_deaths as int)) as TotalDeaths,
SUM(cast(New_deaths as int))/NULLIF (SUM(New_cases, 0), 0)*100 as TotalPercentage
From portfolioproject..
Group by Date_reported Can you please help me about this i got an error it says the sum functions requires 1 argument.

racheljoyo