{"id":696,"date":"2015-02-07T12:13:03","date_gmt":"2015-02-07T10:13:03","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=696"},"modified":"2015-10-16T17:39:26","modified_gmt":"2015-10-16T14:39:26","slug":"bir-tabloda-cift-kaydin-kontrolu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/bir-tabloda-cift-kaydin-kontrolu\/","title":{"rendered":"Bir Tabloda Cift Kaydin Kontrolu"},"content":{"rendered":"<p>Tablonuzda bir kayd\u0131n birden fazla olup olmad\u0131\u011f\u0131n\u0131 merak ediyorsunuz. Baz\u0131 durumlarda bu merak bir mecburiyet haline gelir ve m\u00fckerrer kay\u0131t var m\u0131 yok mu g\u00f6rnek ve d\u00fczeltmek istersiniz. Bu i\u015flem i\u00e7in \u015fu sorguyu kullanabilirsiniz:<\/p>\n<p><strong>SELECT BARCODE, COUNT(*) FROM STOCKS WHERE BARCODE&lt;&gt;&#8221; GROUP BY BARCODE HAVING COUNT(*) &gt; 1<\/strong><\/p>\n<p>Bu sorguda STOCKS tablosunda BARCODE alan\u0131nda, birden fazla ayn\u0131 olan barkodlar\u0131 listeler. E\u011fer ayn\u0131 barkod kodu birden fazla kullan\u0131lm\u0131\u015f ise Barkodu ve yan\u0131nda da miktar\u0131n\u0131 yazar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tablonuzda bir kayd\u0131n birden fazla olup olmad\u0131\u011f\u0131n\u0131 merak ediyorsunuz. Baz\u0131 durumlarda bu merak bir mecburiyet haline gelir ve m\u00fckerrer kay\u0131t var m\u0131 yok mu g\u00f6rnek ve d\u00fczeltmek istersiniz. Bu i\u015flem i\u00e7in \u015fu sorguyu kullanabilirsiniz: SELECT BARCODE, COUNT(*) FROM STOCKS WHERE BARCODE&lt;&gt;&#8221; GROUP BY BARCODE HAVING COUNT(*) &gt; 1 Bu sorguda STOCKS tablosunda BARCODE alan\u0131nda, birden [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,10],"tags":[],"class_list":["post-696","post","type-post","status-publish","format-standard","hentry","category-logorapor","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=696"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/696\/revisions"}],"predecessor-version":[{"id":697,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/696\/revisions\/697"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}