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

Duplicate data exists in the primary key column (collect_date_time) of the subtables in my supertable #25000

Open
Winston-borg opened this issue Mar 4, 2024 · 0 comments
Open

Duplicate data exists in the primary key column (collect_date_time) of the subtables in my supertable #25000

Winston-borg opened this issue Mar 4, 2024 · 0 comments
Labels
help wanted Extra attention is needed question Further information is requested

Comments

@Winston-borg
Copy link

SELECT collect_date_time,count(1) from energy_data where device_id='nyjl50' and project_id='1169307517083373568' group by collect_date_time having count(1)>1
企业微信截图_17095524137517
@Winston-borg Winston-borg added help wanted Extra attention is needed question Further information is requested labels Mar 4, 2024
@danielclow danielclow changed the title 超级表中的子表存在主键collect_date_time 一样的数据 Duplicate data exists in the primary key column (collect_date_time) of the subtables in my supertable Apr 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted Extra attention is needed question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Winston-borg