Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 行转列：SQL SERVER PIVOT与用法解释

行转列：SQL SERVER PIVOT与用法解释

WBOY
Release： 2016-06-07 17:37:20
Original
1132 people have browsed it

在数据库操作中，有些时候我们遇到需要实现行转列的需求，例如一下的表为某店铺的一周收入情况表： WEEK_INCOME(WEEK VARCHAR(10) ,INCOME DECIMAL )

在数据库操作中，有些时候我们遇到需要实现“行转列”的需求，，例如一下的表为某店铺的一周收入情况表：

WEEK_INCOME(WEEK VARCHAR(10),INCOME DECIMAL)

Related labels：
server usage explain
source：php.cn
Previous article： MySQL简单安全的十个设置方法 Next article： Redis实战（3）数据类型一Strings
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Mysql returns some records as empty in date field because date has multiple formats I am trying to analyze order_date column and the column has multiple date formats and I wa...
From 2024-04-06 13:29:40
0
1
466
I'm having trouble with a CSS grid where the height isn't what I expected, what mistakes might I be making? I'm currently learning CSS grids and was asked to make this card by breaking it into a gri...
From 2024-04-06 12:52:14
0
1
339
Try inserting data into a column I have a table called design_designs The table contains 4 columns: id, key, value, nonceId...
From 2024-04-05 11:23:51
0
1
316
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template