Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > distinct和group by 的效率比较？

distinct和group by 的效率比较？

WBOY
Release： 2016-06-23 14:14:28
Original
1845 people have browsed it

不是区别哈，是效率，说说为什么distinct或者group by效率就高啊，不是很明白。。。。。。。。 


回复讨论(解决方案)

distinct 和 group by 是不同的机制，分别使用在不同的场景
所以不能做效率对比

distinct 和 group by 是不同的机制，分别使用在不同的场景
所以不能做效率对比

各自机制和场景能分享下经验吗？

有没有知道的指教一下。。。

Related labels：
distinct和group by 的效率比较？
source：php.cn
Previous article：看看还有谁会犯这两个错误？？？？ Next article：PHP防注入求教？
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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2187
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2333
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1961
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1846
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1899
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