{"id":190,"date":"2010-08-14T23:26:29","date_gmt":"2010-08-14T21:26:29","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=190"},"modified":"2017-04-16T14:40:38","modified_gmt":"2017-04-16T12:40:38","slug":"groupby","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/groupby\/","title":{"rendered":"GroupBy"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">Northwind database devam<\/p>\n<pre class=\"brush:sql\">-- \u00e7al\u0131\u015fanlar\u0131n ID de\u011ferlerini ve o \u00e7al\u0131\u015fan\u0131n toplamda ald\u0131\u011f\u0131 sipari\u015f say\u0131s\u0131n\u0131 hesaplay\u0131n...\r\nselect EmployeeID,\r\nCOUNT(OrderID) as 'Ald\u0131\u011f\u0131 Sipari\u015f Say\u0131s\u0131'\r\nfrom Orders\r\ngroup by EmployeeID\r\n\r\n-- her m\u00fc\u015fterinin ID de\u011ferlerini ve verdikleri sipari\u015f say\u0131lar\u0131n\u0131 listeleyin\r\n-- Orders sipari\u015fler tablosu\r\n-- CustomerID m\u00fc\u015fteri ID de\u011feri\r\nselect CustomerID,COUNT(OrderID)\r\nfrom Orders\r\ngroup by CustomerID\r\n\r\n-- Her sipari\u015fte toplamda ne kadar para kazanm\u0131\u015f\u0131z?\r\nselect OrderID, SUM(UnitPrice*Quantity)\r\nfrom [Order Details]\r\ngroup by OrderID\r\n\r\n-- her \u00fcr\u00fcn\u00fcn ID de\u011ferini ve bu \u00fcr\u00fcnlerin sat\u0131\u015flar\u0131ndan ne kadar para kazand\u0131\u011f\u0131m\u0131z\u0131 listeleyin\r\nselect ProductID, SUM(UnitPrice*Quantity)\r\nfrom [Order Details]\r\ngroup by ProductID\r\n\r\n-- her kategoride toplam ka\u00e7 \u00fcr\u00fcn var?\r\n-- CategoryID ve \u00fcr\u00fcn say\u0131s\u0131 kolonlar\u0131\r\n-- Products tablosu\r\nselect CategoryID,COUNT(ProductID)\r\nfrom Products\r\ngroup by CategoryID\r\n\r\n-- \u00fcr\u00fcn say\u0131s\u0131 10 dan fazla olan kategorilerin ID de\u011ferlerini ve \u00fcr\u00fcn say\u0131lar\u0131n\u0131 listeleyin\r\n-- having =&gt; group by \u0131n \"where\" dir.\r\nselect CategoryID,COUNT(ProductID)\r\nfrom Products\r\ngroup by CategoryID\r\nhaving COUNT(ProductID)&gt;10\r\n\r\n\/*select kolonlar\r\n  from tablolar\r\n  where \u015fartlar\r\n  group by kolonlar\r\n  having sartlar\r\n  order by kolonlar\r\n*\/\r\n\r\n-- toplam sat\u0131lan miktar\u0131 adet bazl\u0131 olarak 50 den fazla olan \u00fcr\u00fcnlerin ID de\u011ferlerini ve sat\u0131lan miktarlar\u0131n\u0131 listeleyin\r\nselect ProductID,SUM(Quantity)\r\nfrom [Order Details]\r\ngroup by ProductID\r\nhaving SUM(Quantity)&gt;50\r\n\r\n-- Birim fiyat\u0131 15 den fazla olan \u00fcr\u00fcnler aras\u0131nda toplam kazand\u0131rd\u0131\u011f\u0131 para 2000 den b\u00fcy\u00fck olan \u00fcr\u00fcnlerin ID de\u011ferlerini ve kazand\u0131rd\u0131klar\u0131 miktar\u0131 listeleyin\r\n-- [Order Details] tablosu\r\n-- UnitPrice =&gt; birim fiyat\r\n-- Quantity =&gt; miktar\r\nselect ProductID,SUM(UnitPrice*Quantity)\r\nfrom [Order Details]\r\nwhere UnitPrice&gt;15\r\ngroup by ProductID\r\nhaving SUM(UnitPrice*Quantity)&gt;2000\r\n\r\n-- en fazla sipari\u015f veren m\u00fc\u015fterilerin ID de\u011ferlerini ve sipari\u015f say\u0131lar\u0131n\u0131 listeleyin\r\nselect CustomerID,COUNT(OrderID)\r\nfrom Orders\r\ngroup by CustomerID\r\nhaving COUNT(OrderID)=\r\n(\r\n    select MAX(Deger) from\r\n    (\r\n       select COUNT(OrderID) as Deger\r\n       from Orders\r\n       group by CustomerID\r\n    )as t\r\n)\r\n\r\n-- en fazla \u00fcr\u00fcne sahip kategorilerin ID de\u011ferleri ve i\u00e7erdikleri \u00fcr\u00fcn say\u0131lar\u0131n\u0131 listeleyin\r\n-- products tablosu\r\nselect CategoryID,COUNT(ProductID)\r\nfrom Products\r\ngroup by CategoryID\r\nhaving COUNT(ProductID)=\r\n(\r\n    select MAX(Deger) from\r\n    (\r\n       select COUNT(ProductID) as Deger\r\n       from Products\r\n       group by CategoryID\r\n    )as t\r\n)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Northwind database devam &#8212; \u00e7al\u0131\u015fanlar\u0131n ID de\u011ferlerini ve o \u00e7al\u0131\u015fan\u0131n toplamda ald\u0131\u011f\u0131 sipari\u015f say\u0131s\u0131n\u0131 hesaplay\u0131n&#8230; select EmployeeID, COUNT(OrderID) as &#8216;Ald\u0131\u011f\u0131<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[40,36],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-groupby","tag-group-by","tag-sql-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GroupBy | F.Murat ALTINI\u015eIK<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fethimurat.com\/blog\/groupby\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GroupBy | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Northwind database devam -- \u00e7al\u0131\u015fanlar\u0131n ID de\u011ferlerini ve o \u00e7al\u0131\u015fan\u0131n toplamda ald\u0131\u011f\u0131 sipari\u015f say\u0131s\u0131n\u0131 hesaplay\u0131n... select EmployeeID, COUNT(OrderID) as &#039;Ald\u0131\u011f\u0131\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/groupby\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-14T21:26:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:38+00:00\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"GroupBy\",\"datePublished\":\"2010-08-14T21:26:29+00:00\",\"dateModified\":\"2017-04-16T12:40:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/\"},\"wordCount\":4,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"group by\",\"sql\"],\"articleSection\":[\"Group By\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/groupby\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/\",\"name\":\"GroupBy | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:26:29+00:00\",\"dateModified\":\"2017-04-16T12:40:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/groupby\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/groupby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GroupBy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GroupBy | F.Murat ALTINI\u015eIK","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fethimurat.com\/blog\/groupby\/","og_locale":"tr_TR","og_type":"article","og_title":"GroupBy | F.Murat ALTINI\u015eIK","og_description":"Northwind database devam -- \u00e7al\u0131\u015fanlar\u0131n ID de\u011ferlerini ve o \u00e7al\u0131\u015fan\u0131n toplamda ald\u0131\u011f\u0131 sipari\u015f say\u0131s\u0131n\u0131 hesaplay\u0131n... select EmployeeID, COUNT(OrderID) as 'Ald\u0131\u011f\u0131","og_url":"https:\/\/www.fethimurat.com\/blog\/groupby\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-14T21:26:29+00:00","article_modified_time":"2017-04-16T12:40:38+00:00","author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"GroupBy","datePublished":"2010-08-14T21:26:29+00:00","dateModified":"2017-04-16T12:40:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/"},"wordCount":4,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["group by","sql"],"articleSection":["Group By"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/groupby\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/","url":"https:\/\/www.fethimurat.com\/blog\/groupby\/","name":"GroupBy | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:26:29+00:00","dateModified":"2017-04-16T12:40:38+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/groupby\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/groupby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"GroupBy"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}