QUERY | 您所在的位置:網(wǎng)站首頁 › 屬豬適合住幾層樓最合適鼠 › QUERY |
?????? ??????? ???? Google Visualization API Query ??? ????? ????????. ???? ?????????QUERY(A2:E6,"select avg(A) pivot B")? QUERY(A2:E6,F2,FALSE)? ??????QUERY(data, query, [headers])? data - ???? ??????? ???? ???? ????? ????????? ?????. ???? ?? ????? ?? ???? ?????? ??? ??? ?????? ?? ????? (??? ?? ??? ????? ???????/?????) ?? ??????? ???. ?? ??? ???? ????? ?????? ?????? ?? ???? ????? ??? ????? ??? ?????? ?????? ?????? ????????? ??? ??? ???????? ??????. ???? ?????? ????? ?????? ????? ????? ?????. query - ????????? ?????? ??????? ???? ?????? ???? Google Visualization API Query. ??? ??? ????? ???? query ??? ?????? ?????? ?? ?? ???? ?????? ????? ????? ??? ???? ???????. ???? https://developers.google.com/chart/interactive/docs/querylanguage ?????? ??? ???? ?? ???????? ??? ??? ?????????. headers - [ ??????? ] - ??? ???? ???????? ?? ???? data. ?? ??? ??????? ?? ??????? ??? ?-1, ??? ????? ?????? ????? ??? ????? data. ?????????? ???? ??????: ??? ??? ?? ???? ?? ????? ??????? ?????? ??. ????? ????????? ?????? Select ?where???? ?????? ???? ??????? ????? ??????? ???????? ?????? Select ?Where. ? Group by?????? ??? Salary ??? ?????? ???????? ?????? Select ?Group by. ? Pivot?????? ????? ??????? ?? ??????? ??? ????? ?????. ? Order by?????? ??? Dept ??? ?????? ???????? ??? ???? ?????? ????? Salary. ? Headers?????? ??? ???? ???????? ?? ???? ???????? ????? ???? ??????? ????? ????? ???? ?????? ???????? ???????? ??? ????? ????? ?? ????. |
今日新聞 |
推薦新聞 |
專題文章 |
CopyRight 2018-2019 實驗室設備網(wǎng) 版權所有 |