SQL 語法範例

一、基本
https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/edit#gid=1467496541

二、總攬查詢
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,E,F&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0

<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,E,F&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>

三、待處理查詢
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,E,F where F = '待處理' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0

四、已完成查詢
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,E,F where F = '已完成'&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0

五、嵌入網頁語法
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>

六、未完成
https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F+%3D+%27%E5%BE%85%E8%99%95%E7%90%86%27&gid=0

七、總攬查詢
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&amp;tq=&amp;key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&amp;gid=0" style="height: 500px; width: 600px;"></iframe>

八、嵌入(已完成查詢)
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&amp;tq=select B,C,D,E,F where F = '已完成'&amp;key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&amp;gid=0" style="height: 500px; width: 600px;"></iframe>

九、嵌入(未完成查詢)
<iframe src="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F+%3D+%27%E5%BE%85%E8%99%95%E7%90%86%27&gid=0" style="height: 500px; width: 600px;"></iframe>

<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>

https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F  order by B desc&gid=0
<iframe src="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F  order by B desc&gid=0" style="width: 600px; height: 500px;"></iframe>

https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,F where C='停電工作' and F = '待處理' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,F where C='停電工作' and F = '已完成' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,E,F where C<>'停電工作' and F = '待處理' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0
https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,E,F where C<>'停電工作' and F = '已完成' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0
即日起預定停電工作
即日起預定一般工作

<table style="border:2px #cccccc solid;" cellpadding="10" border='1'>
<tr><td>這是表格欄位</td><td>這是表格欄位</td></tr>
<tr><td>這是表格欄位</td><td>這是表格欄位</td></tr>
<tr><td>這是表格欄位</td><td>這是表格欄位</td></tr>
</table>

<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,F where C='停電工作' and F = '待處理' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,F where C='停電工作' and F = '已完成' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,E,F where C<>'停電工作' and F = '待處理' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>
<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,E,F where C<>'停電工作' and F = '已完成' order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0" style="width: 600px; height: 500px;"></iframe>

未來預定停電工作
https://zueanes.blogspot.com/2019/12/blog-post_11.html
已完成停電工作
https://zueanes.blogspot.com/2019/12/blog-post_99.html
其他待處理事項
https://zueanes.blogspot.com/2019/12/blog-post_96.html
其他已完成事項
https://zueanes.blogspot.com/2019/12/blog-post_54.html

<iframe src="https://spreadsheets.google.com/tq?tqx=out:html&amp;tq=&amp;key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&amp;gid=1146686294" style="height: 500px; width: 500px;"></iframe>

資料總覽網址

https://spreadsheets.google.com/tq?tqx=out:html&tq=select B,C,D,E,F order by B desc&key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&gid=0

下拉式清單：

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">

<option value="" />最新公告

<option value="https://zueanes.blogspot.com/2019/12/700.html" />109年僱員招考

<option value="" /></select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:red">

<option value="" />課務管理

<option value="https://zueanes.blogspot.com/2019/12/es.html" />課務管理主頁

<option value="https://docs.google.com/forms/d/1Kjjrk-XSlurpOOSX9NS7_DjH9ytQprFApQLlXd-NJV0/viewform?edit_requested=true" />工作預定輸入

<option value="https://spreadsheets.google.com/tq?tqx=out:html&amp;tq=select%20B,C,D,E,F%20order%20by%20B%20desc&amp;key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&amp;gid=0" target="_blank"" />工作事項總攬

<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='待處理'&gid=0" target="_blank"" />待處理事項

<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='已完成' order by B desc&gid=0" target="_blank"" />已完成事項

<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='已完成' and C='停電工作' order by B desc&gid=0" target="_blank"" />已完成停電

<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='已完成' and C != '停電工作' order by B desc&gid=0" target="_blank"" />已完成一般事項

<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/edit?usp=sharing" />事項Excel

</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:orange">

<option value="" />程式編寫範例

<option value="https://zueanes.blogspot.com/2019/11/avascript.html?fbclid=IwAR1XHawOIXN7whiMHf1R1LOuEwTKifa5CF7JCfHVvp0kfg9G-tXDkhv321A" />Java選單

<option value="https://zueanes.blogspot.com/2019/12/sql.html" />SQL語法範例

</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">

<option value="" />教育訓練

<option value="https://zueanes.blogspot.com/2019/12/blog-post_16.html" />電力系統簡介

<option value="https://zueanes.blogspot.com/2019/12/blog-post_22.html" />系統簡介試題

<option value="https://zueanes.blogspot.com/2019/12/blog-post_17.html" />基本低壓控制

<option value="https://zueanes.blogspot.com/2019/12/blog-post_18.html" />屋外變壓器

<option value="https://zueanes.blogspot.com/2019/12/blog-post_71.html" />變壓器概念

<option value="https://zueanes.blogspot.com/2019/12/blog-post_19.html" />變壓器設計

</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">

<option value="" />電力專有名詞

<option value="https://zueanes.blogspot.com/2019/12/blog-post_84.html" />發電廠變電所

</select>

108-12-30更新
<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">
<option value="" />最新公告
<option value="https://zueanes.blogspot.com/2019/12/700.html" />109年僱員招考
<option value="" /></select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:red">
<option value="" />課務管理
<option value="https://zueanes.blogspot.com/2019/12/es.html" />課務管理主頁
<option value="https://docs.google.com/forms/d/1Kjjrk-XSlurpOOSX9NS7_DjH9ytQprFApQLlXd-NJV0/viewform?edit_requested=true" />工作預定輸入
<option value="https://spreadsheets.google.com/tq?tqx=out:html&amp;tq=select%20B,C,D,E,F%20order%20by%20B%20desc&amp;key=1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY&amp;gid=0" target="_blank"" />工作事項總攬
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='待處理'&gid=0" target="_blank"" />待處理之工作
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='待處理' and C='停電工作' order by B asc&gid=0" target="_blank"" />預定停電工作
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,E,F+where+F='待處理' and C!='停電工作' order by B asc&gid=0" target="_blank"" />預定一般工作
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,D,F+where+F='已完成' and C='停電工作' order by B desc&gid=0" target="_blank"" />已完成之停電
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,E,G+where+F='已完成' and C = '一般採購' order by B desc&gid=0" target="_blank"" />已完成之採購
<option value="https://docs.google.com/spreadsheets/d/1_cxCASVGVxbzauE8HsM8RYh9UrOPSGvUbyeAkW6w0uY/gviz/tq?tqx=out:html&tq=select+B,C,E,F,G+where+F != '已完成' and C='一般採購' order by B desc&gid=0 target="_blank"" />待執行之採購
</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:orange">
<option value="" />程式編寫範例
<option value="https://zueanes.blogspot.com/2019/11/avascript.html?fbclid=IwAR1XHawOIXN7whiMHf1R1LOuEwTKifa5CF7JCfHVvp0kfg9G-tXDkhv321A" />Java選單
<option value="https://zueanes.blogspot.com/2019/12/sql.html" />SQL語法範例
</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">
<option value="" />教育訓練
<option value="https://zueanes.blogspot.com/2019/12/blog-post_16.html" />電力系統簡介
<option value="https://zueanes.blogspot.com/2019/12/blog-post_22.html" />系統簡介試題
<option value="https://zueanes.blogspot.com/2019/12/blog-post_17.html" />基本低壓控制
<option value="https://zueanes.blogspot.com/2019/12/blog-post_18.html" />屋外變壓器
<option value="https://zueanes.blogspot.com/2019/12/blog-post_71.html" />變壓器概念
<option value="https://zueanes.blogspot.com/2019/12/blog-post_19.html" />變壓器設計
<option value=" https://zueanes.blogspot.com/2019/12/blog-post_28.html" />超高壓變電所
</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">
<option value="" />電力專有名詞
<option value="https://zueanes.blogspot.com/2019/12/blog-post_84.html" />發電廠變電所
</select>

<select name="pageselect" onchange="self.location.href=options[selectedIndex].value"  style="font-size:16px;color:blue">
<option value="" />竹園E/S圖面
<option value="https://zueanes.blogspot.com/2019/12/es_25.html" />
竹園系統簡圖
<option value=" https://zueanes.blogspot.com/2019/12/blog-post_28.html" />超高壓變電所

</select>