<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>
          

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>
          

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>
          

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>
                <ruby id="bdb3f"></ruby>
                
    


                
  
                                            
                                                        
        
                
          企業??AI智能體構建引擎，智能編排和調試，一鍵部署，支持知識庫和私有化部署方案
          廣告
        
                        
                                            
  

                

                
    
                
        
                
                            # mysql常用工作遇到

### 統計每個人每年

```
<pre class="calibre13">```
<span class="token5">SELECT</span>
	username<span class="token1">,</span>
	<span class="token5">FROM_UNIXTIME</span><span class="token1">(</span>createtime<span class="token1">)</span><span class="token1">,</span>
	<span class="token5">SUM</span><span class="token1">(</span> day_price <span class="token1">)</span> <span class="token5">AS</span> price 
<span class="token5">FROM</span>
	fa_statistics 
<span class="token5">GROUP</span> <span class="token5">BY</span>
	<span class="token5">YEAR</span><span class="token1">(</span><span class="token5">FROM_UNIXTIME</span><span class="token1">(</span>createtime<span class="token1">)</span><span class="token1">)</span><span class="token1">,</span>username

```
```

### 表數據

![](https://img.kancloud.cn/c1/73/c173da7f28ac874a83d8990377a951e4_882x187.png)

### 統計每個人每天

```
<pre class="calibre13">```
<span class="token5">SELECT</span>
	username<span class="token1">,</span>
	createtime<span class="token1">,</span>
	<span class="token5">SUM</span><span class="token1">(</span> day_price <span class="token1">)</span> <span class="token5">AS</span> price 
<span class="token5">FROM</span>
	fa_statistics 
<span class="token5">GROUP</span> <span class="token5">BY</span>
	<span class="token5">DAY</span><span class="token1">(</span>createtime<span class="token1">)</span><span class="token1">,</span>username

```
```

### 結果

![](https://img.kancloud.cn/9c/6f/9c6f0842dc4d69570e88d35c83dd16a2_658x142.png)
                    
                
        
                
            
        
                
    
                
    
                
        
                
    
                

                







                  <ruby id="bdb3f"></ruby>
                  <p id="bdb3f"><cite id="bdb3f"></cite></p>
                    

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>
                        

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>
                        

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>
                        

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>
                              <ruby id="bdb3f"></ruby>
                              

哎呀哎呀视频在线观看