{"version":"1.0","provider_name":"Camdemy1.0","provider_url":"http:\/\/eclass.uch.edu.tw","title":"SELECT\u6558\u8ff0\u7684\u57fa\u672c\u67e5\u8a62","description":"","author_name":"","author_url":"http:\/\/eclass.uch.edu.tw\/user\/","converting":0,"thumbnail_url":"http:\/\/eclass.uch.edu.tw\/sysdata\/doc\/1\/1e7f3e59abdbce38\/thumb_l.jpg","thumbnail_height":360,"thumbnail_width":640,"html":"<iframe width='720' height='540' id='ccShare52014' frameborder='0' scrolling='no' src='http:\/\/eclass.uch.edu.tw\/media\/e\/52014'><\/iframe>","type":"video","width":720,"height":540,"duration":"50:26","index":{"item_1":{"title":"SELECT\u6558\u8ff0\u7684\u57fa\u672c\u67e5\u8a62(\u5927\u6d77\u6488\u91dd)","time":"0","indent":"0","sn":"1"},"item_2":{"title":"\u672c\u7ae0\u5927\u525b","time":"47340","indent":"0","sn":"2"},"item_3":{"title":"6-1 SELECT\u67e5\u8a62\u6307\u4ee4-\u8a9e\u6cd5","time":"108890","indent":"0","sn":"3"},"item_4":{"title":"6-1 SELECT\u67e5\u8a62\u6307\u4ee4-\u5b50\u53e5\u8aaa\u660e","time":"289990","indent":"0","sn":"4"},"item_5":{"title":"6-2 SELECT\u5b50\u53e5","time":"368790","indent":"0","sn":"5"},"item_6":{"title":"6-2 SELECT\u5b50\u53e5-\u8a9e\u6cd5","time":"448790","indent":"0","sn":"6"},"item_7":{"title":"6-2 SELECT\u5b50\u53e5-\u8a9e\u6cd5(M)","time":"473940","indent":"0","sn":"7"},"item_8":{"title":"6-2 SELECT\u5b50\u53e5-\u6b04\u4f4d\u898f\u683c","time":"663540","indent":"0","sn":"8"},"item_9":{"title":"6-2-1 \u8cc7\u6599\u8868\u7684\u6b04\u4f4d-\u67e5\u8a62\u8cc7\u6599\u8868\u7684\u90e8\u5206\u6b04\u4f4d","time":"746090","indent":"0","sn":"9"},"item_10":{"title":"6-2-1 \u8cc7\u6599\u8868\u7684\u6b04\u4f4d-\u67e5\u8a62\u8cc7\u6599\u8868\u7684\u6240\u6709\u6b04\u4f4d","time":"844640","indent":"0","sn":"10"},"item_11":{"title":"6-2-2 \u6b04\u4f4d\u5225\u540d","time":"920840","indent":"0","sn":"11"},"item_12":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u8aaa\u660e","time":"1060440","indent":"0","sn":"12"},"item_13":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u7b97\u8853\u904b\u7b97\u5f0f(\u8aaa\u660e)","time":"1130640","indent":"0","sn":"13"},"item_14":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u7b97\u8853\u904b\u7b97\u5f0f(\u7bc4\u4f8b)","time":"1178840","indent":"0","sn":"14"},"item_15":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u5b57\u4e32\u904b\u7b97\u5f0f(\u8aaa\u660e)","time":"1286990","indent":"0","sn":"15"},"item_16":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u5b57\u4e32\u904b\u7b97\u5f0f(\u7bc4\u4f8b)","time":"1384090","indent":"0","sn":"16"},"item_17":{"title":"MariaDB SQL Functions","time":"1472140","indent":"0","sn":"17"},"item_18":{"title":"Aggregate Functions","time":"1825740","indent":"0","sn":"18"},"item_19":{"title":"String Functions","time":"1926190","indent":"0","sn":"19"},"item_20":{"title":"Date & Time Functions","time":"2025890","indent":"0","sn":"20"},"item_21":{"title":"Numeric Functions","time":"2225940","indent":"0","sn":"21"},"item_22":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u5b57\u4e32\u51fd\u6578(\u8aaa\u660e)","time":"2328390","indent":"0","sn":"22"},"item_23":{"title":"6-2-3 \u8a08\u7b97\u503c\u6b04\u4f4d-\u65e5\u671f\u51fd\u6578(\u7bc4\u4f8b)","time":"2368740","indent":"0","sn":"23"},"item_24":{"title":"6-2-4 \u522a\u9664\u91cd\u8907\u8a18\u9304 - ALL\u8207DISTINCT(\u8aaa\u660e)","time":"2469040","indent":"0","sn":"24"},"item_25":{"title":"6-2-4 \u522a\u9664\u91cd\u8907\u8a18\u9304 - ALL\u8207DISTINCT(\u7bc4\u4f8b)","time":"2613290","indent":"0","sn":"25"},"item_26":{"title":"6-2-5 \u524d\u5e7e\u7b46\u8a18\u9304 - LIMIT\u5b50\u53e5","time":"2655990","indent":"0","sn":"26"},"item_27":{"title":"6-2-5 \u524d\u5e7e\u7b46\u8a18\u9304 - LIMIT\u5b50\u53e5(\u7bc4\u4f8b1)","time":"2864790","indent":"0","sn":"27"},"item_28":{"title":"6-2-5 \u524d\u5e7e\u7b46\u8a18\u9304 - TOP\u5b50\u53e5(WITH TIES\u8207ORDER BY\u5b50\u53e5-\u7bc4\u4f8b)","time":"2918890","indent":"0","sn":"28"},"item_29":{"title":"6-3 FROM\u5b50\u53e5-\u8aaa\u660e","time":"2972140","indent":"0","sn":"29"}},"resolution":{"playtype":"fs","subtype":"","src":"1440x1080","mp4":"720x540","mp4_hd":"1280x960","mp4_1920":"","mp4_4k":"","mp4_src":"1440x1080","mp4_base":""},"base_image":{"thumb":"http:\/\/eclass.uch.edu.tw\/sysdata\/doc\/1\/1e7f3e59abdbce38\/thumb.jpg","cover":"http:\/\/eclass.uch.edu.tw\/sysdata\/doc\/1\/1e7f3e59abdbce38\/cover.jpg","storyboard":"http:\/\/eclass.uch.edu.tw\/sysdata\/doc\/1\/1e7f3e59abdbce38\/video\/thumbs\/storyboard.jpg"},"srcFrom":"","base_url":"http:\/\/eclass.uch.edu.tw\/sysdata\/doc\/1\/1e7f3e59abdbce38","status":true}