Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql去重计数_MySQL

mysql去重计数_MySQL

WBOY
Release： 2016-06-01 13:17:53
Original
2317 people have browsed it

bitsCN.com

要求：

有两个表ttest1、ttest2，结构如下，求 localname ，用户数

ttest1：地区码、用户id

/

/ttest2 ：地区名、地区码/
/sql：
SELECT localname , COUNT( DISTINCT uid )FROM ttest1,ttest2WHERE ttest1.localid = ttest2.localidGROUP BY localname
结果：/
缺陷：对于地区d，没有显示用户为0
大家有什么好的方法，欢迎回复 bitsCN.com
Related labels：
mysql
source：php.cn
Previous article：mysql修改数据库编码(数据库字符集)和表的字符编码的方法_MySQL Next article：MySQL用户执行存储过程的权限_MySQL
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
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
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