<div class="draft-block draft--p left">=QUERY("Driver={SQL Server};Server=193.186.4.169;Database=stock02;Uid=sa;Pwd=sa","select * from Customers")</div>
<div class="draft-block draft--p left">請問老師們有此用法嗎?</div>
<div class="draft-block draft--p left">謝謝</div>
<div class="draft-block draft--p left"></div>

<div class="draft-block draft--p left">這個星期寫了一系列關於聚集函式的文章，包含 SUM、AVERAGE、COUNT、COUNTA、MAX 和 MIN，把新手必備的函式都整理在一起了！想要從零開始學習怎麼寫函式的話，相信是個好開始。</div>
<div class="draft-block draft--p left">
              <a href="/article/65a7eaf4fd89780001ffaa4e" target="_blank" class="draft--mention">
                <i class="icon-blankLink"></i>
                <span>聚集函式御五家：SUM</span>
              </a>
             </div>
<div class="draft-block draft--p left">
              <a href="/article/65a7f5c0fd89780001003666" target="_blank" class="draft--mention">
                <i class="icon-blankLink"></i>
                <span>聚集函式御五家：AVERAGE</span>
              </a>
             </div>
<div class="draft-block draft--p left">
              <a href="/article/65a7f5d5fd89780001003745" target="_blank" class="draft--mention">
                <i class="icon-blankLink"></i>
                <span>聚集函式御五家：COUNT、COUNTA</span>
              </a>
             </div>
<div class="draft-block draft--p left">
              <a href="/article/65a7f60ffd89780001003a14" target="_blank" class="draft--mention">
                <i class="icon-blankLink"></i>
                <span>聚集函式御五家：MAX</span>
              </a>
             </div>
<div class="draft-block draft--p left">
              <a href="/article/65a7f622fd89780001003ad9" target="_blank" class="draft--mention">
                <i class="icon-blankLink"></i>
                <span>聚集函式御五家：MIN</span>
              </a>
             </div>
<div class="draft-block draft--p left">還請多多支持，跟我留言互動按愛心！🙏</div>
<div class="draft-block draft--p left">- - </div>
<div class="draft-block draft--p left">如果有任何想詢問的問題、希望我寫一些主題或是有事情聯絡，你可以：</div>
<div class="draft-block draft--p left">・在<a href="https://vocus.cc/post/652e820afd89780001908e9e" target="_blank" class="draft--a">敲碗區</a>問問題、或是填寫<a href="https://docs.google.com/forms/d/e/1FAIpQLSf3uPZEbvOXnARSHVD6MTsN6OcxKi_06xVeZCWn7SJehuUitA/viewform" target="_blank" class="draft--a">問題表單</a>或是<a href="https://docs.google.com/forms/d/e/1FAIpQLSdP-aj4BZ1onSO0PhDtNHNzt_BQa-27mEZ5eFCMouAU-O6dFQ/viewform" target="_blank" class="draft--a">提案表單</a><br>・直接在教學的文章、或是討論區的文章留言<br>・私訊 <a href="https://www.facebook.com/mrsheet.alex" target="_blank" class="draft--a">Facebook 粉絲專頁</a></div>
<div class="draft-block draft--p left">我是喜特先生，我們下個教學見！</div>

Google 試算表教學站

簡潔，快速，有效，
讓你的日常生活、工作生產力大提升！
＿＿＿
快按「加入」，馬上追蹤所有喜特先生的更新，有 Google 試算表教學、Google Apps Script 的研究、數據分析課程的開箱，還有 Google 試算表疑難雜症的解題分享唷！💪

函式教學