Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Chapter 7 - A small correction to sql code in sumDistinct #64

Open
shanmugavel04 opened this issue Jun 10, 2021 · 0 comments
Open

Chapter 7 - A small correction to sql code in sumDistinct #64

shanmugavel04 opened this issue Jun 10, 2021 · 0 comments

Comments

@shanmugavel04
Copy link

Please find the below correction in book under sumDistinct section
In the book:
--in SQL
select sum(Quantity) from dfTable -- 29310
This query will result in 5176450 rows.
correct one:
--in SQL
select sum(distinct(Quantity)) from dfTable -- 29310
This query will result in 29310 rows.

could you please modify the source accordingly ?
@shanmugavel04 shanmugavel04 changed the title Chapter 7 - Wrong sql code in sumDistinct Chapter 7 - A small correction to sql code in sumDistinct Jun 11, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@shanmugavel04