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

mysql 进一步 #65

Open
liujuanjuan1984 opened this issue Nov 7, 2019 · 4 comments
Open

mysql 进一步 #65

liujuanjuan1984 opened this issue Nov 7, 2019 · 4 comments

Comments

@liujuanjuan1984
Copy link
Owner

除法如何保留小数部分？

默认取整
@liujuanjuan1984
Copy link
Owner Author

round(UA读完一个章节的事件数/UU读完一个章节的用户数+0.00000001,2) as 重复阅读率

不生效

1.*UA读完一个章节的事件数/UU读完一个章节的用户数 as 重复阅读率
生效

@liujuanjuan1984
Copy link
Owner Author

整数和字符串如何比较？
把整数改成字符串

user_activities.meta::json->>'book_id' = concat(books.id,'')

@liujuanjuan1984
Copy link
Owner Author

如何从字符串类型的json文本中匹配某段参数

@liujuanjuan1984
Copy link
Owner Author

两个数据的合集，并集，交集，补集如何计算

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
@liujuanjuan1984