SQL_RollUp Kullanımı Logo Veritabanı Örnekli

Blog Detay

SQL_RollUp Kullanımı Logo Veritabanı Örnekli
SQL_RollUp Kullanımı Logo Veritabanı Örnekli

SQL_RollUp Kullanımı Logo Veritabanı Örnekli

<h2><span style="color:#000000"><strong>SQL ROLL UP Nedir ?&nbsp;</strong></span></h2> <p><span style="color:#000000">Sorgu içinde verdğimiz koşullara göre Alt/Ara toplam alabildiğimiz bir komut.&nbsp;</span></p> <h3><span style="color:#000000"><strong>SQL ROLL UP Kullanımı&nbsp;</strong></span></h3> <blockquote> <p><span style="color:#000000"><strong>&nbsp;&nbsp; &nbsp;Select<br /> &nbsp;&nbsp; &nbsp;IT.CODE,MONTH(STL.DATE_)Ay,sum((STL.AMOUNT)) Fiili<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;FROM LG_003_03_STLINE STL&nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;JOIN LG_003_ITEMS IT ON IT.LOGICALREF=STL.STOCKREF<br /> &nbsp;&nbsp; &nbsp;WHERE LINETYPE=0 AND STL.TRCODE=8<br /> &nbsp;&nbsp; &nbsp;GROUP BY &nbsp;ROLLUP(IT.CODE,MONTH(STL.DATE_))</strong></span></p> </blockquote> <p><span style="color:#000000"><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUAAAAE5CAIAAABu3270AAAAAXNSR0IArs4c6QAANbVJREFUeF7tfQt0HMWZbsv4wdu8ciGEBWw0wpaHS+LHBqS7l5C1CZKdHMFuJiHZjchCJEIeErAOkCgBEi1LcAISBMIoyQaRDQZtLhZgSwQ7EHIi5YFNIMjC1gzGhATw4WUbG/zA1v2qqqfnPfVXz3TPtPzXmWP3jP6ux1f19V9/ddfXVePj4xanggh856buh38zBpMdW187/Kj3KdvVy280hW369Ommp7A9I1AYgUkMEB0Bh730U9iSEfAUASYwCV74Xscu9Zh0MhsxAp4hwAQmQZvqe9kPkyBjI18QYAIbwMy+1wAsNvUFASawAczsew3AYlNfEGACk2DmGJgEExv5jgATmAQ5x8AkmNjIdwSYwAaQcwxsABab+oIAE9gAZo6BDcBiU18QYAKTYOYYmAQTG/mOABOYBDnHwCSY2Mh3BJjABpBzDGwAFpv6ggAT2ABmjoENwGJTXxBgApNg5hiYBBMb+Y4AE5gEOcfAJJjYyHcEmMAGkHMMbAAWm/qCABPYAGaOgQ3AYlNfEGACk2DmGJgEExv5jgATmAQ5x8AkmNjIdwSYwAaQcwxsABab+oIAE9gAZo6BDcBiU18QYAKTYOYYmAQTG/mOABOYBDnHwCSY2Mh3BJjABpBzDGwAFpv6ggAT2ABmjoENwGJTXxBgApNg5hiYBBMb+Y4AE5gEOcfAJJjYyHcEmMAGkHMMbAAWm/qCABPYAGaOgQ3AYlNfEGACk2DmGJgEExv5jgATmAQ5x8AkmNjIdwSYwAaQcwxsABab+oIAE9gAZo6BDcBiU18QYAKTYOYYmAQTG/mOABOYBDnHwCSY2Mh3BJjABpBzDGwAFpv6ggAT2ABmjoENwGJTXxBgApNg5hiYBBMb+Y4AE5gEOcfAJJjYyHcEmMAGkHMMbAAWm/qCQNX4+LgvBQW4kO/c1P3wb8YyGvBAz7WBa9IRRxwRuDpzhQsjwATWjxAQePlDQ84sGn4YxyDwSSedpD+5Yiz++te/MoErpjdKVhGeQpOg5BiYBBMb+Y4AE9gAco6BDcBiU18QYAIbwFzwPvDApQtuidmZDVxapdKlA3l/ccrNMo7dsiB5okH12PQARIAJTOr0wveBBeOqFv8kkdPApYutVVgcHB/7/jOLJYWzf0mWOvDATy4R1qsu+cl18gow8N2rzlz140ZSvUpjtHfv3pdffvmNN94oTXaci48IMIFJYBeOgUNXPgmyzk84WzDyQsm/0Mcvmv/MhpglOJr+S/5CY7dc98z3r/aRvu+9997rr78+ZcqUY445hoQFG1USAkxgg94wjoFDs85cO5qYV8uCsn9pvBp+GrPtxT+55IYrQ8L94j+DSmWa3nLH3SfVnuN88LVAZvv27YPjnTx58nHHHYc6FFEsn1oeBJjABrh78yy08N8y/bjRdr/ZIbRBJa/80sWXfu6T6gQc4GuBk99880144KOPPprZawBxJZkygUm94fJZ6NiGZ+bXprnT7F+S5cdu+czyi+6FF05GxQ8kFsFItUwYXX/Nl0FdfHBQ+ERQd9KkSdu2bePneYwQrhxjJjCpL0zuAzdeeMlPFPFiDy9fe+askJX9S65Ci589p+QK6mrZC3NMno899tjdu3fDFZOAYKMKQ4AJbNAh+WJgsQpdc9XatVfVyBtHjT9eZYmoFr/Zy8nZv2SVmrJ4Jfguo2JfVrOmTp0KDu/atWvr1q0GWLBpZSDAj1Lq+yHfs9D8KKUeO7bwGAH2wCSAXcbApLzZiBFwjwB7YD12vBtJjxFblAkB9sAGwBvfBzbIm00ZATcIMIENUPPmPrBBBdiUEchAgKfQ+iGRcz/w6uU36s9kC0bAYwTYA5MANrkPTMqQjRiBkiDABDaAkWNgA7DY1BcEmMAGMHMMbAAWm/qCAMfAephzxsD/3dWmPzOYFscff3wwK34g1poJrO/1nPeBQeCamhr9yUGzGBsbYwIHqNOYwPrOcgis9CjVCROYwHpEJorFBLhUMYH1g5E9sB6jAFps2bKFCRzAfjOvcr4YON8UurVnXc5C1mX9vDY6z7w63p6RPYV++umnUeT27dtTC37zze1NTUu8rYrHuU8MAvMqNGmYmN4HnuckCxS1P8kf5RGp4Aow2rjx8HPOOefjKemss84a3r2zAqrGVbCYwAaDgH4feJ2TLLjd5LfUI/GXnCneVWer0qr/6loHDSqZNEU+dV1xV6fmPAlOeN0bFj5rNk/NW/nSFcc5URBgAlNQsm2I94HhW6Mt89TnC3PH8S+myvh8/zM71MHQbeEW4YB78pZ99q0xpZM1Ph4bOOPZ7xTBwxLReMOGDbFYbPyFtWObtr39pxJeFgzwZ9NsBJjApFHhej/wzp3JqaYKI6Ffg4SDqVOfpZRd3dB0xu+eS5O2pJxWUpuedevAXsTw69dv3DO6ctq0DQbZb7pz0VFHHdW+OnGK/L7ozk0GWbBpXgSYwKTBYRQDY3wjrV279oknnkDu+Fcl4XN71j366KMrVjxMKlUaxQf7nz17tlDGi3e1qrl1XavyyIm5tvye6mmTx88t+9wVv/vdFSE5l06zp9fAslrmzUMI3NIyr7n5s/hMrV3yhS/MHRiz7o/H8dErwi9YsGB9zGbspkdWPGlSNtsWRIAJbDBA6DHwrFmz5s+fj7Uf5I5/VXrllRM//ekQDsJLPqtxYqBcIgwOfcf65j3t1WDf5/pm3yNn1ffM7vscCDm47IozBsQkO/LsFcvyhMmzl95z69mYkA8jB4p9bjTwZsPXZIITXv7kNhihdRctmA5iIxiORL6r4/AFF8xZ8Yhi8PNj1sUXLzBAnU0LIcAENhgfxBh49+5Z2Zli2vz+97+M32N7j9QX6cTAsYFbrWf7MYGOr+wTnlTSOgSn2rcyHpp9dk9jXV3rytPviUUb9Jma2idz3LNnz6hMO3Y8cfirv3l7kpwA9PRYPa34/667vqDl8PmLbQavXrX+gsWJJ9g23dkupteYUberKbWabjvfM75aq21zYaCm5MkcFtnTcl2eepwCZcEEJnWXUQy8b98fsdqsps0bDz/84YcfVjNneOD77ouNrPw5PruJt2GqG9q/eUZPv/KvLcLf2gkutbp9GN74m7Of+04oRFmoNrVPIjNz5kxnHoG5tP2HlharJbpw4dGX/ehH+AUcLgTlaTWW8MGCv+efpgw33dm6oiYKMcytW6M1K1pB4dW3fX3O/+DrUxes//ptqzO/WtairtXSXBjcDHvk8HXra0/JHC6QXl2bJ6m7A2TEBCZ1llEMjBxxm1eNeMwwzzvvPDVzxrR53j/NC4dFDIl3muzZcwap7IamFjC4eknk7J5+J/YVMe1ga1Vdl9XQHsUs+dmN1ulY61qpYuPYc7lyTrc3XEhW95DELNp5BRrcb2sruD1v3roWkLnwje2Z519gjT0P/s4JzbT5i2D4ya/PlR537teffBL8Pq1mwd2fXLSo/ZFQ9KmuRVbGV+VvpYuGvWDrIyusG7+6yM5P8lebJwnyABkxgQ06ix4DO5li2qzWnO2Z82ZrbL+IIU0Spr7PboxXt98zYPXJOfTnnouIqLhh6a1nyB9CfeI7vj4r59h1y/pTsq8+PWLhZ7joDHuTKkjbk/e/9pdJ8lFwdQe7JWpFoyD21Qv7BHvz3da2ywGD19988/o5ixelFHyx8Ld2Wn35zJmXw8NGv1YzdvPcuZgjZ3xd3T53Rc3XpMt+6sb8UXThPI1bXeEnMIENOogYAyNHTJ7VzFlNm7HsjGmzGPnr1m1dey8+hUrFVFesOTkp8b26IYo5M9JwVP25uj3xg/wup8jyz9GoyME+r0H+LILkDHuDlsu7XzZ7NyfOa4UHng8Cf3dNhJKV8MFPpvAX3xfcvcqJfcWNpdXtCGStRZd3RW8Uy9YZX1HIHOs04W83PTImPLDIEVNtGT1jbUz9osmTUtMg2TCBSb1lFAMjx2uvvfaGG1beffdXenp68O/tt/8mGr0DH3z9WSIR7wOT6ueb0WY8fTLfXkKPRl/rHNyxY8dnTv++zv3K+gmHiomxk2ZeHv0fa4WcQ7eOXRC9fKa16Ks3zpE/zF0hvmd/TZivWG/nGL1x/SdlDjevlzentHn6hpRPBfFuJD3QB/hupPvvj8+dO/7UU1VOlDttZAPuBsP9Aru1X7jrsh9dhqfOcG361a9u1qPpjQW89dxVi9OuD7qCeDODDqEJ93cXMfDEwADrzMPDt4OiKqlGLb/0Vz0tURAb7DV7Nqt0oDj3lebeLJazSpdxYHJiD6zvqgPcA2cD1N+/EkFB9u9l9MD6XsyymBgemAms73rT/cD6HCvY4sCR1GECV/AwLGnVDjQPXFLwODNvEWAPrMf3gNLE0sPBFpWEABNY3xtaD/yLB1bqc2ELRsADBJjAelC1MTAI/M8XeigQ9fLLL5944on6ilaMRSVU2Lc6+FZQzu7lBzlIo970WWhSpmzECBSNABPYAMID9j6wAUZs6i8CTGADvOnPQhtkyqaMQBEIMIFJ4Jk+C03KtDijeHdrvVLtqK9vHbQ3B8YHnR9bu50Ng/Fu21JaO8ZW2u/ib5RdxUXVGjsaq+qTFSsqL/OT09ubVg/8qXz1Mm9J8gwmMAm9SouBMd5CfbUdSrqyt8NqbBasGGwNNVqJH2v7QilDsq7LlrmMddR2pvzB+V3mRNH1IOGVx2iwf6SlJdy3ynAvcjFFZpyb0t6hxasEaVOpG0AaM4ENRkfFxMDxVX1WV29bg9pziG2G40Nt1fHuzpEuaOvYP7YNDYTbs6Wyqhvaerus8nAoPjYSboo2lZXBKd1d3TYE2NS/6ufUY4NxUU5TJrAB+pUSAwv+Rhan7BgWbcCPw+Ga1B9DtXUJMZ60RlbXhIdHy6BTixqGmxqsUK28foj5bGLKjpm157P37H5W/pY9sAEDAmtagTFwDizraoX6rJNA1NyAg9kjY2oaO9zuyF96HQLb/LWqF0cEg/Ff4voy2N/TAmb7kZLtLcMVw4sGsgcmoVppMXDuSmf4VcxYc9vFRh1fnRYDexoCixlCT6MU1YTiiGBwW4cQ+0Lo7h9/rWR7PW0saVCVxIgJbABjpcTAtg9Lr7nwaAm/qv4CnuZ0bCB2hq82wMCtqfC/jqhmTEXhSq4PK1tdS/3xv24rX8HnMYENOqdSYmA5C21v7rZvHuHekbg3A48Wboe+rBKmHOyub8xFDPyhuT3ckVi2MWh9UaYibE9O8BNXIDB4pLFxJCueL6qoA+tkJjCpvystBsZyaSwy2mnrvHdaA72CkQ3R2IClfgx1jkZizupqSqyLP3SkyMCnxcDe3aLNXHZLMjhs1TF/SWMwtxFvZtCDR9mNxJsZUnEkP9+P5076m4Y8CUfJddAPgMIWvhWUsxrsgQ36r1JiYIMqV7CpeCoL02cOf4vqIyawAXwVEwMb1LlyTfH4ybh4AKVyaxiEmjGBSb1UaTEwqdJsdAAgwAQmdXIw7gOTmsJGEwoBXsTSd6dWEwuKHIv+8R/0GRVhgXcP4JVAwfq3iOYG6dTp06eXsbpMYD34lFVoENi7jty2bduufUGaKx180H7v0NB3mLQAaD7UwZ9SCjQ5SMOC2HNemJU9Bj7hWMJrwb1ouas8MVNwdR6fZIwAE5gEWdlj4Fff2E6qaGUYYbZfGRWZ+LVgAhv0cRnvA7MHNuinA8mUCWzQ227uA0P5phR7XfUe+IU7lxx7JHh+wvkLe9aIRj12pfya+rnyUfy+eU1bwrKt54VE83H6+Xdutr8933P+kUvuet4AmnTTAh44qflTNmUdWdcS9YtriEp1IhOYhKSrGFhKMIXa7Zf5kcrJa6TzwI8unf/AJ9ZuB89f/eGFD32q7THL+ugt8usbv/hX6/P3ioPtr95ynrWm7axPWVfalqc/NH9hksOJwh+78kPfqv3FystOc13lvDHwYGujFZHiPrFIHzZeuC6hmBNL2S/F1KMk5zKBSTC6ioGx4wAjdaCFVILGSOOBX4g/t+DC82bITGZcvvKN7o/mzu/5nu+t//ba7o86lvfP+dbtwi07afNdCz8zetPvQfUiUl4PjKevourZq+zdj0WUZ3ZqKfvFrGQPrJnABqBWbgw842OfsK65465HNztT4pzNeuGXDz05p1qxV6XTTp/fuwru2k7wz9+Yc+8jl59qgEoOU8IqdLYCUHFFHqhnM4ENet5NDGyQfSFTXQx8WssPfxEau/ms+Qh6c8yKk1kvOH1majkzqmc7X5+85qzvrZ9v/XRQhtDFJO0qdBybki3exl8Mxva5TGASiK5iYFLORKOcMbC9TCWXpqwZ57XcsgY8/z1mxV90lqOysn9y46bU3zD3Tn79+2//cM3K+z//s+/lP51W3cIeGDFoc1/abmVarmyVAwEmMGlYuIqBSTkTjXJ6YHuZKj1ePXXh4n/NYKlTBmbaC9bHU6fZz29c27zYDphVFL3wq9+2rvlyEUvQKK2AB5aK1pFe3oVE7HidGRNYh1DK3ys2BsbK0wlX2m5z85pVP8uYJyebcFrLv8/51vy2xySHN6+5c8mn1n/7KxnrVZiN32R9ozV7dZqOVF4PLKbO4QFmLx1KnSUTWIdQyt8rNgY+9bLovdYDZ8lbvmd9z7r3h/lXoRZ2//5+6xYRKsNy4yfWrmlJXdNSjZ1x+Q/+w8pYnTaAKb8HHlzWPmwpaUr5lpfy3go2alKlGvNmBn3PUN4P7PVmBvg03TqWviG+WeDqgBtovhWXsyB/thn4U0oBJNkDk4ZZZcbApKqXw0i7Cl2OSk3MMpnABv1asTGwQRt8MSXcB/alHgdAIUxgg06u2BjYoA2+mLIH9gVmUQgTmAR1Zd4HJlW9HEbsgX1DnRex9FATFTn0GRVnwXo6xeHn1dk+6H4UqDoTWN+vksAbYbdj6+uHH3WcOuG/u9pramrUsdLE8q4jy77Uqcco3aISKuxPHfwppQD+PIU2GJxljIENasmmBxICTGBSb8P3SjtxbzNxTDqRjRgBTxFgApPgFb4X5JUf+5h0HhsxAt4iwASm4SufK9qxTfph8jNGvsrHSJ0J+YBifbdUuhDvHspIUgIDbyNNWLYmn2XE6cknG0VeHj3nmCi8vkxyHAIZyOlIBOpT2k8bBpVnxQQ26BOzGNhX+ZjBVuzxkVo1472RvkbBDvnuISUJ0mK/WhuvAYRho9VhW9b2hXLwFCZe7TgAJiOymrEOS1ayDEnuRRYIoA54ybJ8nXJwExOY1Hepvtc+1p7np3xMfGzEec2uUIzJ98LOeHfnSBdeD6zeKAbLgXD7sjQewfnixeApbxDWttPEAJiorUjVodq6kbFykaeuNoRKVOP94sOjMZP6V54tE5jUJ/C9iRBYxMCGz+l7Lx8jXpjdvqx7MF6YEtkVAY96+pMM9tD5puPsPSR5+zXxcnHEEv0jLU0NpAFQsUZMYFLXqL01O2UMbLrPxhf5mOq23oHa0c5QSLdLD84ntcXVNWHn63B7qHOkzkolNAkcUyMRYYfKqKgDrCJ9zfX1zZ1WhyfvFjcFpBh7JrABemYxsMzYU/kYe5lKxZLVDW1RoYIZw6y4QGSXMWfE3DsJQF1X79DQQEtPp7eBoVSFLJ+srOgSCw0dGuqt7fRoqc5gUBVpygQmAZjqe9UxJXktH2MvU6V7kUKRXbaWa2x02JlFqii6YWmXH2s7ZZOVxeTdkg2V0rZW36pyBeKUEaS3YQLrMYKFm/3APsrHiElp4pYIIruejHlysonVbR3hdgiqy0EbH5QLVkszokDMML2isKynXfiqvuFwjVpM8zUhaBi2WVvGQLxkTWYCk6B0EQP7KR8jImCrT8S/eBVEpzXQq8TTc6WGaGzA6pSmoc7R3NqQisLpq9MkmHRGsp6q8GaUXZ4AtCE6EFZYhfrCA+Wpgw4o+t95M4MeK2xmeOgJsZkBfe6sYP28mzcz5IWu7I/4o2b+1MGfUgqMUfbAegLDwl0MTMqajRiBIhBgApPAcxMDkzJmI0agKASYwCT4XMTApHzZiBEoDgEmsAF+Lu4DG+TOpoyAOQK8iKXHTOlCHzbd1uJAPIzj7EUsfUZsMRER8E6JhYIWE1iPktLEGh/fr0yrqibh+OfdV7CkTj7syr42i4r5Uwd/SikwRnkKrScwLBR7d257wzkmncZGjIDHCDCBDQDmGNgALDb1BQEmMAnmVN+rjjkxApWAABOY1Avu7gP7Kh8TDEmdVJ2f8u0E8rVjSAPMtRETmASdmxjYV/mYgEjqCLAT+j62NgcJ/5IaoWN6wkJkKBYpm65PyRrEBDaA0iwG9lM+JiiSOqKe6YoCBvCXyFTs1lJbsKrbonnFh0pUmOfZMIFJEBcVA/uway1AkjrDEMMo59u9hYRBWfYxkgaasRETmASZuxgYWfslHxMcSZ26SEev1A3pw75kEvglN6qz+hO6smWqQemaxAQmYekmBpYZeyofEzxJHcAx1CY0MasblkbKJks5bNUulepDkZFyaduSRh3FiAlMQSn9nQxKn9IgeSUfE2RJHQP4SmsKRY66WkdSp2wXkVI1iglMQnLndvkM1n75PJY81iY/5WOCJ6kTh2BJQppKC2VpDRqahBa2EBXyYXGitFXPkRsTmASxixjYT/mY4EnqQPinq4DwD6lT3BpBU0fp+rCkjlsIg3WekNT59Qblew878lhV+Z/fxpsZ8nZj2R/xR838qYM/pRTgC3tgg4uJ2X1gg4zZlBFwiQATmAScixiYlC8bMQLFIcAEJuHnIgYm5ctGjEBxCDCBSfilrj+rY06MQCUgwIoc+l5wFrGqJk1y2Ju9iKXPiC0mIgIsqVPpvWprYiXWn9VaNK9CF+i2sq/N8ip0pZPK5/rJGNh+Q3Di2OcqcHGMQA4EOAYmDYvx/ftgt3P7m/hXHXNiBCoBASYwqReU84Xvtb0w6SQ2YgQ8R4AJTIL4Hel790vfq47pCXuG/BCPCYakjmVVgJxNogrJfol3J/YXevtuc/qooVoygUlIub8PHO/u7CEVUZxRUCR1KkDOBlWwIjHsJsR2QrUnWbzJ2erAT7EOP95tXlxPZ5zNBCbBmep71TEtYWj0hVvqaMZFWAVFUqcS5GywCTOq3p+css0TQj9yl3JTy/BorIiO8P1UJrAB5MbPQg8u6wt3LK01KMKlaUAkdSpMziaxnVCg17cKGwzjg/0jLU1CLiswiQlM6ipXMfBga6fV4dMb4AMjqVM5cjZy4pxQt+uNQKqrvtm/DiMNO4IRE5gAklx/duyIfhjB70hEih96loInqWNZFSJngyW/5r5IbEjOpcUXq3cIqbe2048FxxKOCCYwCUzzGFhMz4bb5bbxdnHgxbgInKROhcjZgLChvkivYq8U5kiIgziTadKoqAQjJrBBLxB9r8xRqtnJFOuqq+uyr/UGhZmYBkVSx6oEORsxdQ4PJNgruqomPCxD4CCK7DCBSURxFQOTci6JUVAkdSyr/HI2EOMatnoahTR1Qp4alYLIrfgWPJEd3o2kZ5B6P7Bz92jSpINwfO9tV/L7gfNhx5sZ9KOqRBbsgUlAmsfApGzZiBEoEgEmsAGAJjGwQbZsygi4RoAJTIJOxMDj1v59+/CvOubECFQCAkxgUi+4uA9MypeNGIHiEOBFLD1+WMR68PHnYPfO228eesQx6oR7b89cxNJnxBYTEQGW1Kn0XnUIPOmgg8QsOg+BvevISljUNeqkSqiwP3Xwp5QC4PMUmjQy4XulFMd7+Fcdk05jI0bAYwSYwCSAOQYmwcRGviPABCZBLn0vYuC38K865sQIVAICTGCDXjC8D2xvFnKe2DMoyYVpECR1nDomHmQUehjlSj5JHXncPCYwCeBU36uOaallwN7RkPLsPO1MQ6tgSOokd3ioTR5l3Dzvk9SRYTeamzOBSZi5iYGFzE1tiJR90UZBkdRJaSjUSjzeLl0AVb+kjoruWG0GTGAtRMLAZQw8DJmHxJYXUjlujQIiqZNsnpQ7WKz24/qffJM68r5pTGADjA1jYMuqi3T0Yq4oNqt5HO0FRlJHwY099OEOez+9QQeUxtRPqaPS1LhALkxgEsRuYmAEfENtDVLrcGmkbmRM7hgvaQqipI4EQHjAcmnH+SB1VNJO1mTGBCah7SYGJmVclFHgJHVs9+u9Wlh+WP2QOiqqUw1PZgKTAHMRA0uZm0HhduMQgUiILpFKMzYKjKSOPX32Fo2C8PkqdWTckeYnMIENMDOKgaXMTadUteu0uno9DfiCI6mDy1nMipQt/DXo7ICY8m4kfUep9wMfesTRyhTxMI7vvf0qltTJh13ZH/FHxfypgz+lFBij7IH1BIZFZcbApKqz0YRGgAlM6l4XMTApXzZiBIpDgAlsgJ9RDGyQL5syAm4RYAKTkHNzH5iUMRsxAkUhwItYeviULvS+xC7Cgw6ajOPlWYtY+ozYYiIi4J0SCwUtJrAeJRC4//FR2L379luHJNaiswnsXUeWfalTj1G6RSVU2J86+FMKr0KbjsDc9hwDlwZHzqV0CHAMTMISvhc6WPv27cW/6ph0GhsxAh4jwAQmAcz3gUkwBdoojhS8BjCBSX227729cLrvvr0V/6pjUhpslduBq+o93kwoKhMESR1ZTYVJfWt3WemCeuBR9UQvio4KNTeHfOkp0tChGjGBqUjBzjAGHmxt7AkLTZ1YxGr0mMLBkNQBfZvbrY4YIOmw2pvLRGF5qQu19zg9L3cYxsaHhtBTI51lqpXBOEw1ZQKTgHt3x1bYCd+LtWh5rE+D/T11XUsbYFjdFh2PigPPUoAkdSAzJPdIN7UMj8Y8A6RQxmpD0kCLYxMbHQ7XSHUQ8a7vMtXKJRRMYBJwLmJgcMqyhwWpiKKMgiKpI+rZtwpz5/hg/0gZJe3SwE4VLwvVeiK9UFTnFjyZCUzCNtX3qmNKqrP6EwGf1/KpQZHUQT0jEAqrb+60OrydlFA6aALYMIENOtEwBraGrdqlYraGyMqTGDh4kjoIP5ut3iGk3trO+mBFmwYDxUdTJjAJbBcxMMKpulqlu4iJoycTs8BJ6kDPJiHG4UymSfh7apQa+CbDYU+LLF3mTGASli5iYKuhKdy+TGnqrOpLrJKQSjM2CoqkjqCKDIF9wMQAxGTg66eWt0EFC5gygUk4uoqBG6IJTZ2+8ICnAV9gJHUACSR2xX3gkNeYkPpVGVW3dYha1eNecBnVbg0qnGLKmxn0uInNDI+th91Bk6c4K1jLf/DvLKmTD7uyP+KPihnXQTyIVV1tqDVvXIp+uJlZsAcm4eUiBibly0aVgwDIa8jeSqg7E5jUC25iYFLGbMQIFIUAE5gEn6sYmJQzGzECxSDABDZAz/Q+sEHWbMoIuEKAF7H0sCld6EMOP0qZIh7GcfYilj4jtpiICHinxEJBiwmsR8nWxEo8QanWonkVugBwZV+bRd38qYM/pRSAmqfQegLDgmNgEkxs5DsCTGADyDkGNgCLTX1BgAlMglneBx7f994eoYklj0mnsRERgWDK2RAb56kZE5gEr4v7wI7EjRTVQfJYkyMgkjoC7nLL2eST9cHuLmeHlJ9qSKQhmMeICUxCT/perD9vk/GwONam5ItoxYbCrjpvt68HRFJHKXeVV84mn6wPhHUclR2oIQmRHSn948lOUO3woRowgalIwc51DDy4rC8ixXW8SoGR1KkMOZscsj6gdV+4pU51UBLO6oalXSP9XssxFDEsmMAk8FJ9rzo2SFIzTe0M9ioFRVInq/1lkLPJKeuDS2y4Y2mtXb+0bY+jwyNjZRXQLDhomMAkTrmIgZ18sRs47Pkr6YMiqUNC22OjbFmfwdYMhR9n22P9slHLdsse18pl9kxgEnAuYuBEvuLa3uTN9Dl4kjoksD02ypL1kTOkzAinISrEkMaHok1QRqrgxAQ26BwXMXDOwWFQZEHTwEnqZLfGfzmbLFmfQeilDLcLlYFQuzhIl+ryVVzUxcBgApNAE3Ev3smwd494P4M8pqWU0UI7wZ1VUCR1crTOdzmbLFmfBikTLRLuFdR1xYbaqi3MbeSbI+KDy9qHvb1/4K7HnbOYwCQAXcbA8ZgV8Tz8RQMCI6mTwwX7LmdDkfURakhC+ifUONLirRoSafgVMOLNDHoEhaTOr0Zg9+7ObYccNl2dsPyOpSypkw8740f8XcnZFO454zroB0IOC39KKVA19sAG/eYiBjbI/UA2DaacTSX0GBOY1AvwvQh739u7B/+qY06MQCUgwAQm9YLLGJiUNxsxAu4RYAKTsIPvhd2uneIZLHXMiRGoBAR4EUvfC1jEWiEXsSZPmeqw976sRSx9RmwxERFgSZ1K71WliXVwYv0ZfhjH2QT2riPLvtRp2kOVUGF/6uBPKbwKbToCM+05Bi4WQT7fGwQ4BibhyjEwCSY28h0BJrAB5Hwf2AAsNvUFASYwCWa5/jz+3t7d+FcdU07LJ91COdfYJrCSOqKl6SI7xm03O8HexCV1jgL/knEmMKnz3cTA+aRbSAWaGgVWUidbZMe06W7sWwbs/Qti50KgExOY1H3S9+I+8Hb8q45JKYd0C+k8Y6PgSupgI4bYDDTQYtxmtycE7yXehVrKBDYYB2YxcE7pFoPSTEwDK6lj0sjS2Q73NUNbbwJMoC2LCUwaFqm+Vx0TUrZ0C+EklyYsqWMCXF2koxfbfwfCfSGPxX5NauXKlglMgs1dDFzfbPUOIfXWdnqyWMKSOqTOyzDCnH2orQGhLxQnI3WVLFhHaR0TmIKSHfcaxcBZ0i2lVzacAJI6JPTZKD8CTGCD0WEUA2dJt3i43BlgSR0D+EtjKrEaFFdToZdjeaz3W5o6F8iFCUyC2E0MTJFuIRWuNwqwpI6+cSW2kFh1Sg27TqurN+i3kXg3kn58qPcDO3ePJk+ZhuP77vgaS+rkw67sj/ijYv7UwZ9S2APrWVrYwuV94GKL5fMZAQ0CPIU2GCJGMbBBvmzKCLhFgAlMQs5NDEzKmI0YgaIQYAKT4HNzH5iUMRsxAkUhwItYeviEpM6aZ2G3653tBx96pDrhvjszF7H0GbHFRETAOyUWClpMYD1KDoEnT5323h57J0M2gb3ryLIvdeoxSreohAr7Uwd/SimAP0+hSYMTvhd2ir3qmBMjUAkIMIFJvcAxMAkmNvIdASYwCfJU3+vMoklnshEj4CUCTGAiutDQGZd+WBwQJXUGW+Wu06p6P/asBVZSJ4GSj/I2vnYMcYC5NGMCk4Db9c7bMgbeJWNgcaxPg62NI5GYeO1sh9XoNYUDK6kDlCyJ0ngs4tPuXBTZExaaOrGI9x2jHyfFWTCBSfi5iIGTKjfYd9o10j9IKsilUXAldbAlMqo2FEBVxJfduYP9PXVdSxtEiW0oXBwEODGBSZ2X6nvVsTalbSccHfZ24/hEkNTBBurhcI2Hmy5Vl+FaZ/lQjHZ8lMiACWwApNmz0M52wvplo1adQTFuTAMvqSM1PJVj9DzVWf1qdcKXxQlvm8MEJuHrJga2rIaoEFwcH4o2WcOkYgyNJoykDhbgmvsiMW80Xjdvtn79a/tz113WbY9cMrzu36YtGr/uujeOHPzj/H+xrr/eamiwzj3X/nz+8+KX1E9/v336008b9pD35vwklh5jez9wYuY8eerBmEXfd+fV5P3AGJ+h0Q734Zbh4z7gdX9TsrTUr4Ip0OlK7mJ3/pj8i6htkWzSVTithu7K27XL+v3vk30Hiqr0xBP2gfOLvoPNLY46yvrgB8VpM2fu+bu/m3rwwdZZZ4mv+BF/8jMxgfVog8APrPkz7Ha/8/a0Q49QJ9yvJbAYpbWxaJuFFeJGa8A9f/V70+UVIoKyEEHGUVxnbYo3S+czvqEysShU3eKD3c2NCaqmUtsdpVKA1BL441Wj/+fxqz6MU/72/778L5svXHHVpHTntnGj9eqraV2Drxs26Dsrw8JhGn4/9VTrlFPwf3zlDRtmfWVJ9TFv/vX+S7ZcvELWIy1lXB3wtxdftODJkeCEt24tVA1F5lmzrOOPtz7yEVEoPt4lJrAeW4fAU6YevDfhh/UEtsDc+sYeTJ7rWgaG1GonBoEaB0b+Yffu3dOmTcNZJ5wgRkZqwlf8KGnbLMuSpfUKfiZShkNOMa1r6eq1l4DFCxJSfDNlzoAmqOYosoFdGZTTI+vWIpWWKcwU4Eg0xMEhh2zL+3R6dseY10S1d+fOnS+9dJhquCI55gXgf2pClUDpD39Y/IsPGF7CxATWg6neD+z4XuWHtQRGR+Jq/Yc/uGGsvk75LTKGiHIFGcmZ8qnf4SgoSfkl8BbT1MIXoJqa/SeeSF1ewfg+/fRk+dkXKUVIxUx60s0C6DkVssxZClw0uh4fUBr/ZmCFtlx9tfXpT5eGyUxgfUeqGNjxvcoPZxP4hRemY3w/84zos9TwLLUARZXEXC75lwxG4Q9qEKjkeGD11Qnz1NdUS31jcln8539a11yT91SMvwcfFKMwdQkHdEJbQDzlDDPq7w95CjfWnzoQS1HoYWxgYKhAAACCxpddViyNmcD6MV8gBoZTwhJltOel50ZP2rKlyslLDWs4wzPPFF2V06voC05YEEeJk6EzUccvGC5f/KKmKHiD5ubMkYSm/fKXonVqzo8E14EWgbRNTZkz+YwCTCtMh4Ju6U8dXJQCMnd3C2AdGgN/0/mFgwMTWD8kcsbAV118w6pVJ6EbnIAHwxp0VQsYpV23cDFKnFaheiCwQ0L1eyrDte1Hi0BvtI4+yIqpsLY+RAN/6uC6FDjkG26waawujpjRfOxjAmejxATWw5URA+/cdtDrL1361pa/x5mYOgLxY4975mtLZ5x8si3Woc/R0ML1KClcjlqGUf9u25Y2Q1bO4ZxzxKjKWDaj1N2jClOKdmz8qUORpYDG0agIT5wFdlwuBwcN7kUxgfWjIjUGfvOV+r/FLtq395APfGBvZ+eUiy8Wp//igZWL/vEf9BmxxUREoCRKLLiGPvKIIDOCZEzfHn+cOoljAuvHlJpC73vv0BfXf3r76/XCO8146NEHZ59xRkidrAhcko7MWZsiL/P6FpbaQlZ4W6lzNctPVGH6dLNzzK1L2zUq3rn7bjHr+dOfSOtb1LV+86ZNtDM2PX0F2Dtl6rbQ/P84YeaD06ZhVzAnRqCUCCAi++lPRVCGGTWe6KQkJjAFJeu1v/zvndtmHnLEX2ad3TF5yjOkc9iIEXCFADiMWfR991l4clubmMBaiITBW1v+Cf+ePPunB01+x2xPUnb2cSRSoWx0YCKAe5ArVoimX3GF/uE2JrB+kOx4+9B3tp8E9zvpoPWwdp7o0J8Ji3h3K95mmTAVWi6h5uaQBxvZAiGpE/+v+qoLu53rF77W/5f89nhr1bUpkgeJr0mDBILZv5C6Ic0ot6JOSk85WEpFJCSvBVUy24CHCPCMB0Li735X0zwmsL7/X3vtGBgdduQm4XvHx+2P/jw5DELtPY5lvLtTiOwMDUHMZaQzOY71WWktgiKpg4asa29WpC1TyiF1lNlT1W1yH6hKsa66liZf9imnAXLddWIRSz3vUSAxganDaPLUbXt3vwvr3e/uoJ2jhsFAi2MdG01ITgi5jtEYLRuKVWAkdbDX4rqu8MplngoMFUQsl9RRVk+l5DC4rC/ij85AerXVFgjtIzdMYD0/tr6V9oSG6xhYDJ1a+85TqLak+k+BktRZvHTJSGfZnLCZ1JGcNC32XOcn9yBUW47zPVevzmEC6wnsWCjfq/xwhaVASepU/1tHGZ2widQRdLrCHUn5A587XW3SwhYInkIXhfyuXWIvLpJr31tU8flPDq6kTkP0K1b5nDBZ6gjT53AZwt9EjysPXFjGgD2wnly73rUJbBgDZ+acGvgmw2F9+XktIMkqUroyanVDU0u++DpbuRX1cFZo6uRcERq4VntzSVfYcjXg3KWRlc3LnGWAGbV1G8eSq9MvjNSF7GCjCHx0p2oEKuX0uRzhb6LeavdIYSEuJrCuly3ruPe9CaPx/VOK9cPJwDc1HNZXQGshVlFbbc7Fhe5xItTOuoa0dYTbQ62DkiqQ1KlvHMlSgsRs3A8KV7d9Jdxzb0Ls79Sa8LrR2GZV33gsNhye4VXgiXmLxCo+uKw9efXKxhjTZ6ts4a+sDmX7FxNYyw7rff/rLRjteueEYmPgatCnD/eAcS+4tKGViIAt5CxSqNMa6M0ftjVEYwNWpzQNdUJHK5cSpKKw5yvF5y7tmueg3xB9orb/yvr6C/Fp7g/Foufafxq+IVR1SpX6tD4ufsz+Rd+HKRaIgSVWocaRloH8uu7xmBUpX/gr66vEdwpLcPFmBn3nX9f5g87rWnEb6cxzr3NWsO7/4TVkVcr0IsSDWNXVJv6ltE/M6xtctAVvZigaQjuDqipB43fzL5uyB9ZDPXnyvoMPH9uz67itr50Ia/J94Dw5g7wm7NXXjy0mKALK9xYWh2ACkzr/uA88JyYzchN/pa1FkxrARgFEQOmoMIFL0HVHHDs0adLe1//2EfjhirwPXII2chaVhoC6gcQELkG/YBvw8TMexEL0iyOt+xPL0SXIl7NgBPIjoHYyQCirQOJFLP0IUppYU6YdvemZK3a8NWv6+34944x7shex9BmxxUREwCPdD2zohzQHnuWANAcTuKiBY2ti7X53757psbXfwCz6+FMGfvNotctVaPO6BHMV2nM5m8JA+gOaR6Uo9mJjMMSx1PNY+RIvYpH4pOLe/fv+NvODt2JP/5YXG7/0pRML36Aj5ctGjEA6Atg/+KEPUdmLU5nABiMI688HH/oKNLHw75o1h8+YYXV1Zb4IxyA7NmUEEghAWRb6GxhRF1wgnp3ERsLf/U7je9WpTGDSIEp9BquqKgYOL1y4Ax5Ygb5q5YyM91mRMi2VkZFGj5Fxdg2LPL1UTZ4o+cDfQoby/e8XryaGM8B9IyjaYdoM9hLluJnApLGQeu8Xx5hF33HHy1hdANxQ9L37p3POPPPI3N44XVJHFJb9C6kKuY1ya/TkKcLIOLuqJdMDKikCLsErXx2wv/emm8QrxQ85RPhbKNdhCEFA/9ZbrRdeEGpYxHfNsQc26Pq9u9/Bdgbph8fVMU7G6gLgfu456yPnvoQXIylvnELjLEkd8Q7PdJEdgyrkMs2h0ZO/CCPj7KqWRg+o1Ai4AdDvOmB2hhny9dcLusLZnn22de21QsZdvdYDGpSvvCK8bns7Vcw9tdHsgQ2GQM5nsDDV+dKXn/nzn9/GWxpwKQWNsQghVRSyhVoKSbcY1MMxzaHRk78II+PsypdGD6jUCLhBzY86YABgGRlEBV3haTFDVm9Cwgg5/3wLr4PEJPmtt4QDwLCh7DrK11AmMGkI7H53J+yk78Wz0OI4I5188n5cSjEFQvfgARp0Gz6Q9vU0GWn0GBnnCH690wPyFCO/MoePBWNx+QZXsQMBvY9bQZgqq1el4P2DmCHDzUITEa8+wstcsUxVksQEJsEI34tJs/qo45wJXYXuwQfdg5676CJMmT76W+uzL8ln4jhNAATUK87VlBh0XbLkMMRNYCx4C8YigMKf4FFxHYesJEYCrun4LF8uZshGwS0RKyYwCag90vfukb5XHRdI6DxMkHC5xXX31VenjVr/t3W2uCTjCl3OxWpSQw9oI0VOkBDkxAecVJ/ZswVF1Qf9qH7ElBiWv/3tZCwd43qNaFYxFgEtPjhADhgJpX3RbHb3MIENhqzRPiRcbnHdfeWVx+ZZK48+QThkXKERDsEnr7SuuvtaMb/CcCnmaRAjjR4j42xQijzdAGW/TPdZU/78a9ELuJHjzHtxAL8KcuKjPG3quz/BRnQrPoquiGD/+Me3MSvG9RrHirHFBLQums7PQrsAzc0piIfxwntcrTEgMhJWszEm8DJeXMh97n43LQnmOQp29TJk6DziIEMsTukw4xXtKqFT8CQjEtaKSxWveoEcE9gLVDV5qmEEn/zii2kXeJym3tQOMmMAEW/ll6EBFVmk0kBXryxHeuKJJGNz1hcI43PKKYKfgNrrua5HmDGBPQLWIFuMOfgHDLjU2Zo6H2MLAwv6wBhhcBHq3wM5YRFBCZ0rom7ZYjvVwtqrDm64MgJPNROeGIkJXFn9qMiMOR6GqXLU2cmZ1GEgwoEgYTgqek+ApJiJpQElp7pxow1CduiR2ljVfHyOP94GBP9V+Oy3JJ3FBC4JjF5lohyOGtNqKDsjOx+x4bSnTbP9jLJBLFd4S5pXtdflmxqX/uEPommFXyOC/JzQFAfTp4srV8W2Ttf60vydCVwaHP3PRY1+uCmMe8TSOZfH8tUqddDj2Fm5ySaDQxhKAzPexKXqppKqIVKBC5DjMx1H6pTOsUM+/JnAlJEZGBtFIfVxOKNqX5g5/rfQISemDJj3qkW7AzzCd9EL/x/epNqKArnwzQAAAABJRU5ErkJggg==" style="height:313px; width:320px" /></span></span></span></p> <p><span style="color:#000000">Yine logo veritabanını baz alarak vereceğim örneğimi, SQL sorgularını sadece Logo veritabanı üzerinde kullanıyorum.Basit bir aylık satış toplamı aldığımız bir sorgu. Roll up sayesinde Yıl sonunda toplamı da sorgu içinde görebilmek mümkün.</span></p>

Bunu paylaş
SQL CTE(Common Table Expressions) Kullanımı_Logo Veritabanı Örnekli
SQL Pivot Table Kullanımı_Logo Veritabanı Örnekli
Yazar erydogan
1992 yılı İstanbul doğumluyum. "Beykent Üniversitesi/Bilgisayar Programcılığı" bölümü mezunuyum, 7 yılı aşkın süredir Logo firmasının üretmiş olduğu ERP ürünlerine teknik destek vermek üzere “Logo Erp Danışmanı/Sistem Uzmanı” olarak çalıştım. 2020 Şubat ayında yıllardır hayalini kurduğum "kendi işimi yapma" düşüncemi hayata geçirmek üzere DGN Yazılım firmasını kurdum. Ayrıca .Net C# (MVC) yazılım dilini kullanarak Web tabanlı/Mobil Uyumlu, Logo yazılım entegreli ya da tamamen bağımsız uygulamalar geliştiriyorum.

İlişkili Bloglar:

0 Yorum

Copyrights © 2020 All Rights Reserved by DGN Software.