Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > SQL 必知必会笔记8分组数据

SQL 必知必会笔记8分组数据

WBOY
Release： 2016-06-07 17:39:49
Original
1194 people have browsed it

1. 使用GROUP BY子句创建分组 示例: SELECT vend_id, COUNT ( * ) AS num_prods FROM Products GROUP BY vend_id;

1. 使用GROUP BY子句创建分组

示例:

SELECT vend_id, COUNT(*) AS num_prods FROM Products GROUP BY vend_id; ，网站空间，香港空间，网站空间

Related labels：
Group Must know data notes
source：php.cn
Previous article： Oracle 行迁移 & 行链接的检测与消除 Next article： resetlogs 打开数据库时新生成日志位置问题
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
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
From 2024-04-06 20:22:15
0
1
454
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
for loop randomly goes from 1 to 0 Basically, every time the page is refreshed, the for loop has the potential to change from...
From 2024-04-06 16:48:14
0
1
393
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