Judy

Like open source, follow open source

Joined on Oct 23, 2023 https://github.com/SPLWare/esProc

Judy

Apr 26

Types of equi-joins

#sql #join #eaui #development

4 min read

Want to connect with Judy?

Create an account to connect with Judy. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Judy

Apr 25

Calculate the Total Price According to the Cumulative Price Table

#sql #database #development #laugenge

1 min read

Judy

Apr 22

JOINs in SQL

#sql #join #development #langange

5 min read

Judy

Apr 19

How to Transpose Rows to Columns on Multiple Fields in Each Group

#sql #database #data #development

2 min read

Judy

Apr 17

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

#sql #database #development #language

1 min read

Judy

Apr 15

How to Replace a Null with the Corresponding Value in the Previous Record

#sql #development #database #laugange

1 min read

Judy

Apr 11

How to Calculate Median on Values That Have Corresponding Quantities

#sql #database #development #laugunge

2 min read

Judy

Apr 7

What You Possibly Don’t Know About Columnar Storage

#database #data #storage #programming

6 min read

Judy

Apr 3

a very tool for developing quantitative strategy model

#development #quantitaive #programming #model

9 min read

Judy

Apr 1

How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows

#development #sql #coding #devops

2 min read

Judy

Mar 28

How to Convert Dates in One Group into An Interval

#sql #database #dataengineering #development

2 min read

Judy

Mar 22

How to Handle Different Data Types during Row-to-Column Transposition

2 min read

Judy

Mar 18

How to Transpose Columns in Each Group to a Single Row

#sql #database #coding #dataengineering

2 min read

Judy

Mar 14

The difficulty of SQL stems from relational algebra

#sql #language #maths #learning

6 min read

Judy

Mar 11

Which Scenarios Does ClickHouse Applies to?

#clickhouse #development #sql #esproc

5 min read

Judy

Mar 5

Actually, you will never be able to master Python

#python #study #beginners #programming

7 min read

Judy

Feb 27

Is SQL a declarative language

#sql #opensource #devops #esproc

5 min read

Judy

Feb 18

How come there are tens of thousands of tables in a database

#programming #sql #esproc #development

5 min read

Judy

Jan 31

What to do if the query calculation is moved out of database but is too slow using java

#java #github #coding #esproc

6 min read

Judy

Jan 24

How Much Is One Terabyte of Data?

#discuss #programming #opensource #softwaredevelopment

6 min read

Judy

Jan 15

SQL looks like English is a well-intentioned error

#discuss #programming #devops #sql

4 min read

Judy

Jan 3

Improving JOIN Performance: Foreign Key Pointerization

#join #java #programming #development

4 min read

Judy

Dec 27 '23

The Syntax of Discreteness - Using SQL as an Example

#sql #database #programming #development

4 min read

Judy

Dec 20 '23

Set-oriented Syntax – Using SQL as an Example

#devops #sql #programming #database

4 min read

Judy

Dec 15 '23

About Using SQL for Big Data Computing

#programming #devops #database #sql

4 min read

Judy

Dec 13 '23

Relational Algebra Is the Root of SQL Problems

#programming #devops #database #sql

5 min read

Judy

Dec 11 '23

Four Ways to Improve Back-end Performance for Multidimensional Analysis

#programming #devops #opensource

7 min read

Judy

Dec 6 '23

Order-based Group Operations (II)

#learning #data #backend #developer

4 min read

Judy

Dec 1 '23

Order-based Group Operations (I)

#devops #opensource #softwaredevelopment #sql

6 min read

Judy

Nov 7 '23

It's been nearly 50 years. Is SQL outdated?

14 min read

DEV Community

Judy

Badges

Writing Debut

2 Week Community Wellness Streak

4 Week Writing Streak

1 Week Community Wellness Streak

Types of equi-joins

Want to connect with Judy?

Calculate the Total Price According to the Cumulative Price Table

JOINs in SQL

How to Transpose Rows to Columns on Multiple Fields in Each Group

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

How to Replace a Null with the Corresponding Value in the Previous Record

How to Calculate Median on Values That Have Corresponding Quantities

What You Possibly Don’t Know About Columnar Storage

a very tool for developing quantitative strategy model

How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows

How to Convert Dates in One Group into An Interval

How to Handle Different Data Types during Row-to-Column Transposition

How to Transpose Columns in Each Group to a Single Row

The difficulty of SQL stems from relational algebra

Which Scenarios Does ClickHouse Applies to?

Actually, you will never be able to master Python

Is SQL a declarative language

How come there are tens of thousands of tables in a database

What to do if the query calculation is moved out of database but is too slow using java

How Much Is One Terabyte of Data?

SQL looks like English is a well-intentioned error

Improving JOIN Performance: Foreign Key Pointerization

The Syntax of Discreteness - Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

About Using SQL for Big Data Computing

Relational Algebra Is the Root of SQL Problems

Four Ways to Improve Back-end Performance for Multidimensional Analysis

Order-based Group Operations (II)

Order-based Group Operations (I)

It's been nearly 50 years. Is SQL outdated?