{"id":102,"date":"2011-10-02T10:39:11","date_gmt":"2011-10-02T10:39:11","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=102"},"modified":"2011-10-02T10:39:11","modified_gmt":"2011-10-02T10:39:11","slug":"8-matematines-funkcijos","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=102","title":{"rendered":"8. Matematin\u0117s funkcijos"},"content":{"rendered":"<p>Standartin\u0117s ANSI SQL-92 apra\u0161o SQL matematini\u0173 operacij\u0173<br \/>\npalaikym\u0105. Pagrindiniai veiksmai yra:<\/p>\n<p><span style=\"color: #ff0000;\">+<\/span> sud\u0117tis;<br \/>\n<span style=\"color: #ff0000;\">&#8211;<\/span> atimtis;<br \/>\n<span style=\"color: #ff0000;\">*<\/span> daugyba;<br \/>\n<span style=\"color: #ff0000;\">\/<\/span> dalyba;<br \/>\n<span style=\"color: #ff0000;\">%<\/span> liekanos trupmenos skaitiklis<\/p>\n<p>Reikt\u0173 atkreipti d\u0117mes\u012f , kad ne visos DBVS palaiko %.<\/p>\n<p>Kitos matematin\u0117s operacijos, kurie atlieka skai\u010diavimus<br \/>\npateiktus duomen\u012f x.<\/p>\n<p><span style=\"color: #ff0000;\">ABS(x)<\/span> \u2013 gr\u0105\u017eina x vert\u0117s modul\u012f.<br \/>\n<span style=\"color: #ff0000;\">SIGN(x)<\/span> \u2013 gr\u0105\u017eina teigiamas, nulis ar neigiamas atitinkamai kaip -1, 0 ar 1.<br \/>\n<span style=\"color: #ff0000;\">MOD(x,y)<\/span> \u2013 atitinka operacij\u0105 x%y.<br \/>\n<span style=\"color: #ff0000;\">FLOOR(x)<\/span> \u2013 gr\u0105\u017eina did\u017eiausi\u0105 sveik\u0105 skai\u010di\u0173, kuris yra ma\u017eesnis arba lygus x.<br \/>\n<span style=\"color: #ff0000;\">CEILING(x)<\/span> arba <span style=\"color: #ff0000;\">CEIL(x)<\/span> \u2013 gr\u0105\u017eina ma\u017eiausi\u0105 sveik\u0105 skai\u010di\u0173, kuris yra didesnis arba lygus x.<br \/>\n<span style=\"color: #ff0000;\">POWER(x, y)<\/span> \u2013 gr\u0105\u017eina vert\u0119 x pakelta y laipsniu.<br \/>\n<span style=\"color: #ff0000;\">ROUND(x)<\/span> \u2013 suapvalina x iki artimiausio sveikojo skai\u010diaus.<br \/>\n<span style=\"color: #ff0000;\">ROUND(x, d)<\/span> \u2013 suapvalina x iki nurodyt\u0173 d de\u0161imt\u0173j\u0173 \u00a0(sveikas skai\u010dius nurodo po kablelio, o neigiamas prie\u0161 kablel\u012f).<br \/>\n<span style=\"color: #ff0000;\">SQRT(x)<\/span> \u2013 i\u0161traukia \u0161akn\u012f.<\/p>\n<p>Operacijos gali b\u016bti vykdomos tiek atskiroms vert\u0117ms, tiek kiekvienos eilut\u0117s atskiro stulpelio domenui. Pavyzd\u017eiui, suapvalinkime visas kainas:<\/p>\n<blockquote><p>SELECT preke, ROUND(kaina), kaina FROM uzsakymu_sarasas;<\/p><\/blockquote>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. Suapvalinkite visas kainas 10 cent\u0173 tikslumu ir i\u0161vesikite \u012f ekran\u0105 visus prek\u0117s pavadinim\u0105 ir jos suapvalint\u0105 kain\u0105.<br \/>\n2. Suapvalinkite visas kainas 10 lit\u0173 tikslumu, t\u0173 preki\u0173, kurios kainuoja ne ma\u017eiau 10 lit\u0173. Ekran\u0105 i\u0161veskite prek\u0117s pavadinim\u0105 ir jos suapvalint\u0105 kain\u0105.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Standartin\u0117s ANSI SQL-92 apra\u0161o SQL matematini\u0173 operacij\u0173 palaikym\u0105. Pagrindiniai veiksmai yra: + sud\u0117tis; &#8211; atimtis; * daugyba; \/ dalyba; % liekanos trupmenos skaitiklis Reikt\u0173 atkreipti d\u0117mes\u012f , kad ne visos DBVS palaiko %. Kitos matematin\u0117s operacijos, kurie atlieka skai\u010diavimus pateiktus duomen\u012f x. ABS(x) \u2013 gr\u0105\u017eina x vert\u0117s modul\u012f. SIGN(x) \u2013 gr\u0105\u017eina teigiamas, nulis ar neigiamas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-102","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102"}],"version-history":[{"count":2,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/102\/revisions"}],"predecessor-version":[{"id":104,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/102\/revisions\/104"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/13"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}