DEV Community

Judy profile picture

Judy

Like open source, follow open source

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

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

5
Comments 1
2 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.

Already have an account? Sign in
In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

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

5
Comments 1
1 min read
How to Replace a Null with the Corresponding Value in the Previous Record

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

6
Comments 1
1 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

5
Comments
2 min read
What You Possibly Don’t Know About Columnar Storage

What You Possibly Don’t Know About Columnar Storage

5
Comments
6 min read
a very tool for developing quantitative strategy model

a very tool for developing quantitative strategy model

8
Comments
9 min read
How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows

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

6
Comments
2 min read
How to Convert Dates in One Group into An Interval

How to Convert Dates in One Group into An Interval

5
Comments
2 min read
How to Handle Different Data Types during Row-to-Column Transposition

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

6
Comments
2 min read
How to Transpose Columns in Each Group to a Single Row

How to Transpose Columns in Each Group to a Single Row

7
Comments
2 min read
The difficulty of SQL stems from relational algebra

The difficulty of SQL stems from relational algebra

15
Comments 1
6 min read
Which Scenarios Does ClickHouse Applies to?

Which Scenarios Does ClickHouse Applies to?

6
Comments
5 min read
Actually, you will never be able to master Python

Actually, you will never be able to master Python

8
Comments
7 min read
Is SQL a declarative language

Is SQL a declarative language

13
Comments 5
5 min read
How come there are tens of thousands of tables in a database

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

7
Comments 1
5 min read
What to do if the query calculation is moved out of database but is too slow using java

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

7
Comments 1
6 min read
How Much Is One Terabyte of Data?

How Much Is One Terabyte of Data?

14
Comments 2
6 min read
SQL looks like English is a well-intentioned error

SQL looks like English is a well-intentioned error

12
Comments 5
4 min read
Improving JOIN Performance: Foreign Key Pointerization

Improving JOIN Performance: Foreign Key Pointerization

6
Comments
4 min read
The Syntax of Discreteness - Using SQL as an Example

The Syntax of Discreteness - Using SQL as an Example

6
Comments
4 min read
Set-oriented Syntax – Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

6
Comments 1
4 min read
About Using SQL for Big Data Computing

About Using SQL for Big Data Computing

6
Comments 1
4 min read
Relational Algebra Is the Root of SQL Problems

Relational Algebra Is the Root of SQL Problems

12
Comments 2
5 min read
Four Ways to Improve Back-end Performance for Multidimensional Analysis

Four Ways to Improve Back-end Performance for Multidimensional Analysis

5
Comments
7 min read
Order-based Group Operations (II)

Order-based Group Operations (II)

5
Comments
4 min read
Order-based Group Operations (I)

Order-based Group Operations (I)

5
Comments
6 min read
It's been nearly 50 years. Is SQL outdated?

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

6
Comments 2
14 min read
loading...