{"id":863,"date":"2024-09-20T10:04:39","date_gmt":"2024-09-20T02:04:39","guid":{"rendered":"https:\/\/oloawa.top\/?page_id=863"},"modified":"2025-03-26T11:34:13","modified_gmt":"2025-03-26T03:34:13","slug":"python","status":"publish","type":"page","link":"https:\/\/oloawa.top\/index.php\/python\/","title":{"rendered":"python"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"863\" class=\"elementor elementor-863\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9cd86de e-flex e-con-boxed e-con e-parent\" data-id=\"9cd86de\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-869ee9e elementor-widget elementor-widget-text-editor\" data-id=\"869ee9e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>select ename,sal from emp ORDER BY sal DESC;<br \/>select empno, ename, sal from emp where sal &gt;= 2000 and sal &lt;= 3000;<br \/>select ename,sal from emp where ename LIKE &#8216;S%&#8217;;<br \/>select ename,sal,comm from emp where comm is NULL;<br \/>select AVG(sal) as avg_sal from emp;<br \/>select empno, ename, sal from emp where sal &gt;= 2073;<br \/>select deptno, AVG(sal) as avg_sal from emp GROUP BY deptno;<br \/>select deptno, AVG(sal) as avg_sal from emp GROUP BY deptno having AVG(sal) &gt;2500;<br \/>select count(*) from emp where deptno in (20,30)GROUP BY deptno;<br \/>select ename,sal from emp where CHAR_LENGTH(ename)=5<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>select ename,sal from emp ORDER BY sal DESC;select empn [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-863","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/pages\/863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/comments?post=863"}],"version-history":[{"count":64,"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/pages\/863\/revisions"}],"predecessor-version":[{"id":963,"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/pages\/863\/revisions\/963"}],"wp:attachment":[{"href":"https:\/\/oloawa.top\/index.php\/wp-json\/wp\/v2\/media?parent=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}