tag:blogger.com,1999:blog-69646786575750455622024-03-20T11:17:37.850+03:00Yazılıma Dair Örnek ve Pratik BilgilerBu blog yazılarımda temelde c# ve ERP olmak üzere c, c++, java ,veri yapıları, algoritmalar , yazılım ve bilişim sektörüne yönelik öğrendiğim faydalı ve pratik bilgileri sizlere aktarmaya çalışacağım. halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-6964678657575045562.post-57218949137060668892018-09-17T01:39:00.001+03:002018-09-17T01:41:31.864+03:00ALİBABA.COM NEDİR?<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9deYsrbB5hF_k4AOJ9ow3ahZbXRq61litv0i1XFjB8pKGCCIQutVGeFI5ozT5v1MNd9qIR6tHewU43J3x7D1rurG6hZeQcKd5RoOOZ1un9Tv9qzpt9GuztjG_XzT17Ct7Fl2FmZrPW14/s1600/alibaba-nedir.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="1000" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9deYsrbB5hF_k4AOJ9ow3ahZbXRq61litv0i1XFjB8pKGCCIQutVGeFI5ozT5v1MNd9qIR6tHewU43J3x7D1rurG6hZeQcKd5RoOOZ1un9Tv9qzpt9GuztjG_XzT17Ct7Fl2FmZrPW14/s400/alibaba-nedir.jpg" width="400" /></a></div>
<br />
<br />
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
Merhaba başlık ile ilgili web site ve yazı linki aşağıdadır.</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
İlgili Yazı : <a href="http://alibabaihracat.com/blog/alibaba-com-nedir.html" rel="nofollow">ALİBABA.COM NEDİR? YAZISI</a></div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0px; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
Web Site : <a href="http://alibabaihracat.com/">ALİBABAİHRACAT.COM</a></div>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-15071130177789409882018-09-17T01:35:00.001+03:002018-09-17T01:41:27.548+03:00ALİBABA GOLD ÜYELİK DESTEĞİ<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixedENlBep5mhqHxnNDvUpT22Ru0AVYs-F41-VBVX_2Iw0UyH8kglhJSxtaEVUzDa-G6TN5TOeHkGiyg3vykUhw5N2BI8UBxrjbXURB1OxuWKiSVvZKfmCfi6hSD8zoeCC2P0PVXsWvUA/s1600/alibaba.com-gold-uyelik-destegi.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="440" data-original-width="800" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixedENlBep5mhqHxnNDvUpT22Ru0AVYs-F41-VBVX_2Iw0UyH8kglhJSxtaEVUzDa-G6TN5TOeHkGiyg3vykUhw5N2BI8UBxrjbXURB1OxuWKiSVvZKfmCfi6hSD8zoeCC2P0PVXsWvUA/s400/alibaba.com-gold-uyelik-destegi.jpg" width="400" /></a></div>
<br />
<br />
Merhaba başlık ile ilgili web site ve yazı linki aşağıdadır.<br />
<div>
<br /></div>
<div>
İlgili yazı : <a href="http://alibabaihracat.com/blog/alibaba-gold-uyelik-destegi.html" rel="nofollow">ALİBABA GOLD ÜYELİK DESTEĞİ YAZISI</a></div>
<div>
<br /></div>
<div>
Web site : <a href="http://alibabaihracat.com/">ALİBABAİHRACAT.COM</a></div>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-4781167195132245542018-09-17T01:26:00.004+03:002018-09-17T01:27:09.205+03:00ALİBABA GOLD SUPPLİER ÜYELİK DETAYLARI<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7k4ZL4JECMywT51fTH7azv-h85z_kwzCqnDik2h8-lXulSsemfSR2Rcpwey_4XSr5omlwUkJ9oUx1qk3v8kFc0Ox60SFkY4zJGC9W2dYrxGjwfoXPreImjZwPOzkzFOkgGNDLTXt28Z0/s1600/alibaba-gold-uyelik-alibaba-ihracat-danismanlik-alibaba-detaylar.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="413" data-original-width="550" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7k4ZL4JECMywT51fTH7azv-h85z_kwzCqnDik2h8-lXulSsemfSR2Rcpwey_4XSr5omlwUkJ9oUx1qk3v8kFc0Ox60SFkY4zJGC9W2dYrxGjwfoXPreImjZwPOzkzFOkgGNDLTXt28Z0/s400/alibaba-gold-uyelik-alibaba-ihracat-danismanlik-alibaba-detaylar.jpg" width="400" /></a></div>
Merhaba başlık ile ilgili web site ve yazı linki aşağıdadır.<br />
<br />
İlgili Yazı : <a href="http://alibabaihracat.com/blog/alibaba-gold-supplier-uyelik-detaylari.html" rel="nofollow">ALİBABA GOLD SUPPLİER ÜYELİK DETAYLARI YAZISI</a><br />
<br />
Web site : <a href="http://alibabaihracat.com/">ALİBABAİHRACAT.COM</a>halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-26695137434198688872018-09-17T01:19:00.000+03:002018-09-17T01:41:24.934+03:00ALİBABA İLE İHRACATIN FİRMALARA FAYDALARI<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpdIGxc_3Zv4wrFsT7mie934zIALK29sDjXTkH2R63l-dZBsrfgXrHjbZXoSNeZPNazRHhyUimAUUkKR9UrpIw1VMAsGIGiKluSCYG7WoNVjvCEsFIimI19dNiPGWjENMlZdkOE0UIocM/s1600/alibaba-ihracat-alibaba-gold-uyelik-alibaba-danismanlik-alibaba-ile-ihracat-yapmak.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="404" data-original-width="647" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpdIGxc_3Zv4wrFsT7mie934zIALK29sDjXTkH2R63l-dZBsrfgXrHjbZXoSNeZPNazRHhyUimAUUkKR9UrpIw1VMAsGIGiKluSCYG7WoNVjvCEsFIimI19dNiPGWjENMlZdkOE0UIocM/s400/alibaba-ihracat-alibaba-gold-uyelik-alibaba-danismanlik-alibaba-ile-ihracat-yapmak.jpg" width="400" /></a></div>
<br />
<br />
Merhaba başlık ile ilgili web site ve yazı linki aşağıdadır.<br />
<br />
İlgili yazı :<a href="http://alibabaihracat.com/blog/alibaba-ile-ihracatin-firmalara-faydalari.html">ALİBABA İLE İHRACATIN FİRMALARA FAYDALARI YAZISI</a><br />
<br />
Web site : <a href="http://alibabaihracat.com/" rel="nofollow">ALİBABA İHRACAT & DANIŞMANLIK</a><br />
<br />
<br />
<br />halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-15202433906672583452018-02-01T17:27:00.000+03:002018-02-01T17:28:47.312+03:00CROSS JOIN<pre><span class="c1" style="color: #008800; font-style: italic;">--CROSS JOIN...:Tablodaki tüm kayıtları birbiri ile </span>
<span class="c1" style="color: #008800; font-style: italic;">--kartezyen çarpım yaparak birbiri ile ilişkilendirir</span>
<span class="c1" style="color: #008800; font-style: italic;">---------------------------------------------------</span>
<span class="c1" style="color: #008800; font-style: italic;">--soru...:Hangi personel hangi ürünlerden satış yapmamıştır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">p</span><span class="p">.</span><span class="n">Adi</span><span class="p">,</span><span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Personeller</span> <span class="n">p</span> <span class="k" style="color: #aa22ff; font-weight: bold;">cross</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span>
<span class="n">Urunler</span> <span class="n">u</span> <span class="c1" style="color: #008800; font-style: italic;">--buraya kadar yaptıgımız kartezyen çarpımdır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">except</span><span class="c1" style="color: #008800; font-style: italic;">--hangi personel hangi üründen satış yapmıştır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">p</span><span class="p">.</span><span class="n">Adi</span><span class="p">,</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Personeller</span> <span class="n">p</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Satislar</span> <span class="n">s</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span> <span class="n">s</span><span class="p">.</span><span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">p</span><span class="p">.</span><span class="n">PersonelID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="n">sd</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span> <span class="n">sd</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">SatisID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">sd</span><span class="p">.</span><span class="n">UrunID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">p</span><span class="p">.</span><span class="n">Adi</span> <span class="p">,</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span>
<pre><span class="c1" style="color: #008800; font-style: italic;">---------------------------------------------------</span></pre>
<span class="c1" style="color: #008800; font-style: italic;">--soru...: Hangi tedarikçiden hangi ürün hiç tedarik edilmemiştir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">t</span><span class="p">.</span><span class="n">SirketAdi</span><span class="p">,</span><span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">cross</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Tedarikciler</span> <span class="n">t</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">except</span><span class="c1" style="color: #008800; font-style: italic;">--aşagıda hangi tedarikçi hangi ürünü tedarik etmiştirin cevabı</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">t</span><span class="p">.</span><span class="n">SirketAdi</span><span class="p">,</span><span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Tedarikciler</span> <span class="n">t</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">t</span><span class="p">.</span><span class="n">TedarikciID</span><span class="o" style="color: #666666;">=</span><span class="n">u</span><span class="p">.</span><span class="n">TedarikciID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">t</span><span class="p">.</span><span class="n">SirketAdi</span><span class="p">,</span><span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span>
<pre><span class="c1" style="color: #008800; font-style: italic;">---------------------------------------------------</span></pre>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi ürün hangi müşteriye hiç satılmamıştır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">m</span><span class="p">.</span><span class="n">MusteriAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">cross</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Musteriler</span> <span class="n">m</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">except</span> <span class="c1" style="color: #008800; font-style: italic;">--Hangi ürün hangi müsteriye satılmıştır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">m</span><span class="p">.</span><span class="n">MusteriAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="n">sd</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">u</span><span class="p">.</span><span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">sd</span><span class="p">.</span><span class="n">UrunID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Satislar</span> <span class="n">s</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">s</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">sd</span><span class="p">.</span><span class="n">SatisID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Musteriler</span> <span class="n">m</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">m</span><span class="p">.</span><span class="n">MusteriID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">MusteriID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">u</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">m</span><span class="p">.</span><span class="n">MusteriAdi</span></pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-25380384036410110642018-02-01T09:47:00.000+03:002018-02-01T09:47:51.435+03:00SQL OUTER JOIN<pre><span class="c1" style="color: #008800; font-style: italic;">--OUTER JOIN</span>
<span class="c1" style="color: #008800; font-style: italic;">--outer join(dış birleşim)...:İlişkili tablolardaki null </span>
<span class="c1" style="color: #008800; font-style: italic;">--kayıtlar dahil bütün kayıtalrı getirir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--3 Çeşit outer join(dış birleşim) vardır.</span>
<span class="c1" style="color: #008800; font-style: italic;">--1. si left outer join(sol dış birleşim)..:left join de soldaki </span>
<span class="c1" style="color: #008800; font-style: italic;">--null dahil bütün kayıtlar getirilir.Diger tablonun ise sadece ilişkili </span>
<span class="c1" style="color: #008800; font-style: italic;">--kısımlarını getirir. </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Musteriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Satislar</span><span class="p">.</span><span class="n">MusteriID</span><span class="o" style="color: #666666;">=</span><span class="n">Musteriler</span><span class="p">.</span><span class="n">MusteriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--2.si right outer join(sağ dış birleşim)...:right joinde</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--sağdaki tablonun null dahil</span>
<span class="c1" style="color: #008800; font-style: italic;">--bütün degerlerini getirir. Diger tablonun ise sadece ilişkili verileri gelir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">right</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Satislar</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">SatisID</span>
<span class="c1" style="color: #008800; font-style: italic;">--3.sü ise full outer join...: Her iki tabloda null</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--kayıtlar dahil bütün kayıtları getirir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">full</span> <span class="k" style="color: #aa22ff; font-weight: bold;">outer</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Kategoriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">Kategoriler</span><span class="p">.</span><span class="n">KategoriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--soru..:Kesişim kümesi hariç diger alanları listele</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">full</span> <span class="k" style="color: #aa22ff; font-weight: bold;">outer</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Kategoriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Kategoriler</span><span class="p">.</span><span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Kategoriler</span><span class="p">.</span><span class="n">KategoriID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">IS</span> <span class="k" style="color: #aa22ff; font-weight: bold;">NULL</span> <span class="k" style="color: #aa22ff; font-weight: bold;">OR</span> <span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">IS</span> <span class="k" style="color: #aa22ff; font-weight: bold;">NULL</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi tedarikçiden toplamda kaç dolarlık ürün tedarik edilmiştir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--(tüm tedarikçiler gelmelidir.)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Tedarikciler</span><span class="p">.</span><span class="n">TedarikciID</span><span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">Urunler</span><span class="p">.</span><span class="n">Fiyat</span><span class="p">)</span></pre>
<pre><span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Tedarikciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span><span class="o" style="color: #666666;">-</span>
<span class="n">Urunler</span><span class="p">.</span><span class="n">TedarikciID</span><span class="o" style="color: #666666;">=</span><span class="n">Tedarikciler</span><span class="p">.</span><span class="n">TedarikciID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">Tedarikciler</span><span class="p">.</span><span class="n">TedarikciID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hiç satış yapılmayan müşterilerimizi listeleyen sorguyu yazınız.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Musteriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Musteriler</span><span class="p">.</span><span class="n">MusteriID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">MusteriID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Satislar</span><span class="p">.</span><span class="n">SatisID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">Is</span> <span class="k" style="color: #aa22ff; font-weight: bold;">null</span>
<span class="c1" style="color: #008800; font-style: italic;">--nakliye edilmeyen siparişleri listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Nakliyeciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Nakliyeciler</span><span class="p">.</span><span class="n">NakliyeciID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">ShipVia</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Satislar</span><span class="p">.</span><span class="n">ShipVia</span> <span class="k" style="color: #aa22ff; font-weight: bold;">IS</span> <span class="k" style="color: #aa22ff; font-weight: bold;">NULL</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Nakliyeciler</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hiç nakliye yapmayan nakliyecileri listeleyen sorguyu yazınız.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Nakliyeciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Nakliyeciler</span><span class="p">.</span><span class="n">NakliyeciID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">ShipVia</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Satislar</span><span class="p">.</span><span class="n">ShipVia</span> <span class="k" style="color: #aa22ff; font-weight: bold;">IS</span> <span class="k" style="color: #aa22ff; font-weight: bold;">NULL</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi personel hangi üründen hiç satış yapmamıştır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Urunler</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">Personeller</span><span class="p">.</span><span class="n">adi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Personeller</span> <span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Personeller</span><span class="p">.</span><span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">PersonelID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Satislar</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">SatisID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">left</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Urunler</span><span class="p">.</span><span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">UrunID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">Urunler</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">Personeller</span><span class="p">.</span><span class="n">adi</span></pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-27534144650802563192018-01-25T14:05:00.001+03:002018-01-25T14:05:19.020+03:00Sql inner join<pre><span class="c1" style="color: #008800; font-style: italic;">--JOİN...: İlişkili birden fazla tabloyu </span>
<span class="c1" style="color: #008800; font-style: italic;">--birleştirmek için kullanılan bir yöntemdir. </span>
<span class="c1" style="color: #008800; font-style: italic;">--3 Çeşit join vardır.İnner join, outer join, cross join</span>
<span class="c1" style="color: #008800; font-style: italic;">--İnner join...: Tablodaki NULL olmayan kayıtları listeler</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">UrunAdi</span><span class="p">,</span> <span class="n">fiyat</span><span class="p">,</span><span class="n">Stok</span><span class="p">,</span><span class="n">KategoriAdi</span><span class="p">,</span><span class="n">Tanimi</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">kategoriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">Kategoriler</span><span class="p">.</span><span class="n">KategoriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Ürünleri ve sadece şirket isimleriyle ile birlikte listeleyiniz </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Urunler</span><span class="p">.</span><span class="o" style="color: #666666;">*</span><span class="p">,</span><span class="n">SirketAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Tedarikciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span></pre>
<pre> <span class="n">Tedarikciler</span><span class="p">.</span><span class="n">TedarikciID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">TedarikciID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Yapılan satışları müşteri adı sayadı ve personel adı,</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;"> -- soyadı ile birlikte listeleyiniz. </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Satislar</span><span class="p">.</span><span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="n">MusteriAdi</span><span class="o" style="color: #666666;">+</span><span class="n">MusteriUnvani</span><span class="p">)</span> <span class="s1" style="color: #bb4444;">'musteri ad soyad '</span><span class="p">,</span></pre>
<pre><span class="p"> (</span><span class="n">Adi</span><span class="o" style="color: #666666;">+</span><span class="n">SoyAdi</span><span class="p">)</span><span class="s1" style="color: #bb4444;">'personel ad soyad'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span></pre>
<pre> <span class="n">Musteriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span> <span class="n">Satislar</span><span class="p">.</span><span class="n">MusteriID</span><span class="o" style="color: #666666;">=</span><span class="n">Musteriler</span><span class="p">.</span><span class="n">MusteriID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Personeller</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span> <span class="n">Personeller</span><span class="p">.</span><span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">PersonelID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi personel hangi üründen taplamda kaç dolarlık satış yapmıştır</span>
<span class="c1" style="color: #008800; font-style: italic;">--(personel ürünler satisdetay satis)</span>
<span class="c1" style="color: #008800; font-style: italic;">--ilk iş bunları bir birine joinleyelim</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Personeller</span><span class="p">.</span><span class="n">Adi</span><span class="o" style="color: #666666;">+</span> <span class="s1" style="color: #bb4444;">' '</span><span class="o" style="color: #666666;">+</span><span class="n">Personeller</span><span class="p">.</span><span class="n">SoyAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">as</span> <span class="n">personel</span><span class="p">,</span></pre>
<pre><span class="n">Urunler</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">Adet</span><span class="o" style="color: #666666;">*</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">Fiyat</span></pre>
<pre><span class="o" style="color: #666666;">*</span><span class="p">(</span><span class="mi" style="color: #666666;">1</span><span class="o" style="color: #666666;">-</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">Indirim</span><span class="p">))</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span></pre>
<pre><span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Personeller</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Satislar</span><span class="p">.</span><span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">Personeller</span><span class="p">.</span><span class="n">PersonelID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Satislar</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">SatisID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">Urunler</span><span class="p">.</span><span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">SatisDetay</span><span class="p">.</span><span class="n">UrunID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">Urunler</span><span class="p">.</span><span class="n">UrunAdi</span><span class="p">,</span><span class="n">Personeller</span><span class="p">.</span><span class="n">Adi</span><span class="o" style="color: #666666;">+</span><span class="s1" style="color: #bb4444;">' '</span><span class="o" style="color: #666666;">+</span><span class="n">Personeller</span><span class="p">.</span><span class="n">SoyAdi</span>
<span class="c1" style="color: #008800; font-style: italic;">--hangi personel hangi kategoriden toplam kaç adet ürün satışı yapmıştır.</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--(Personel,satis,satisdetay,kategori)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="p">(</span><span class="n">p</span><span class="p">.</span><span class="n">Adi</span><span class="o" style="color: #666666;">+</span><span class="n">p</span><span class="p">.</span><span class="n">SoyAdi</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">as</span> <span class="s1" style="color: #bb4444;">'Personel adı ve soyadı'</span> <span class="p">,</span><span class="n">k</span><span class="p">.</span><span class="n">KategoriAdi</span><span class="p">,</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">sd</span><span class="p">.</span><span class="n">Adet</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">as</span> <span class="s1" style="color: #bb4444;">'sattıgı adet'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="n">s</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Personeller</span> <span class="n">p</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">p</span><span class="p">.</span><span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">PersonelID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="n">sd</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">sd</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">SatisID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Urunler</span> <span class="n">u</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">u</span><span class="p">.</span><span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">sd</span><span class="p">.</span><span class="n">UrunID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Kategoriler</span> <span class="n">k</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">k</span><span class="p">.</span><span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">u</span><span class="p">.</span><span class="n">KategoriID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">p</span><span class="p">.</span><span class="n">Adi</span><span class="o" style="color: #666666;">+</span><span class="n">p</span><span class="p">.</span><span class="n">SoyAdi</span><span class="p">,</span><span class="n">k</span><span class="p">.</span><span class="n">KategoriAdi</span>
<span class="c1" style="color: #008800; font-style: italic;">--Nakliyeci şirket adı 'speedy Express' olan nakliyeci,</span>
<span class="c1" style="color: #008800; font-style: italic;">-- satış fiyatı 15 dolardan yüksek kaç adet ürün taşımıştır.</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--(nakliyeciler,satislar,satisdetay,)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">n</span><span class="p">.</span><span class="n">SirketAdi</span> <span class="p">,</span> <span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">sd</span><span class="p">.</span><span class="n">Adet</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="n">s</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">Nakliyeciler</span> <span class="n">n</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">n</span><span class="p">.</span><span class="n">NakliyeciID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">ShipVia</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">inner</span> <span class="k" style="color: #aa22ff; font-weight: bold;">join</span> <span class="n">SatisDetay</span> <span class="n">sd</span> <span class="k" style="color: #aa22ff; font-weight: bold;">on</span>
<span class="n">sd</span><span class="p">.</span><span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">s</span><span class="p">.</span><span class="n">SatisID</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">n</span><span class="p">.</span><span class="n">SirketAdi</span><span class="o" style="color: #666666;">=</span><span class="s1" style="color: #bb4444;">'Speedy Express'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="n">sd</span><span class="p">.</span><span class="n">Fiyat</span> <span class="o" style="color: #666666;">></span><span class="mi" style="color: #666666;">15</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">n</span><span class="p">.</span><span class="n">SirketAdi</span> </pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-77911010189258438502018-01-22T12:29:00.000+03:002018-01-23T15:37:00.149+03:00SQL ALT SORGULAR<table class="pastetable" style="color: black; font-family: Verdana, arial, helvetica, sans-serif;"><tbody>
<tr><td class="linenos" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="linenodiv" style="border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; margin: 0px; padding: 0px;">
<pre></pre>
</div>
</td><td class="code" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="paste" style="background-color: #eeeeee; border-radius: 4px; border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; color: black; margin: 0px; padding: 0px;">
<pre> <span class="c1" style="color: #008800; font-style: italic;">--ALT SORGULAR 1 (İç içe sorgular)</span>
<span class="c1" style="color: #008800; font-style: italic;">--1.Kullanım şekli:Select ile from arasınabir sorgu yazılır.</span>
<span class="c1" style="color: #008800; font-style: italic;">--Bu sorgu geriye sadece bir sütun döndürür.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">Select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">KategoriAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Kategoriler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span><span class="p">)</span>
<span class="s1" style="color: #bb4444;">'kategori adı'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--Urunler tablosunu tedarikçi adı ile birlikte listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">SirketAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Tedarikciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">TedarikciID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">TedarikciID</span><span class="p">)</span>
<span class="s1" style="color: #bb4444;">'ŞİRKETADLARI'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--Ürünler tablosunu tedarikçi adı ve kategori adı, ürün adı, fiyat ve stok</span>
<span class="c1" style="color: #008800; font-style: italic;">-- bilgileri ile birlikte listeleyiniz. </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">UrunAdi</span><span class="p">,</span><span class="n">Fiyat</span><span class="p">,</span><span class="n">Stok</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">KategoriAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Kategoriler</span></pre>
<pre> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">KategoriID</span><span class="p">)</span>
<span class="s1" style="color: #bb4444;">' Kategori Adı'</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">Select</span> <span class="n">SirketAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Tedarikciler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> </pre>
<pre><span class="n">TedarikciID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">TedarikciID</span><span class="p">)</span><span class="s1" style="color: #bb4444;">'Tedarikçi Adı'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--Satışlar tablosunu müşteri adı unvanı(aynı hücrede), personel adı soyad(aynı hücre)</span>
<span class="c1" style="color: #008800; font-style: italic;">-- ile birlikte listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">MusteriAdi</span><span class="o" style="color: #666666;">+</span><span class="s1" style="color: #bb4444;">' '</span><span class="o" style="color: #666666;">+</span><span class="n">MusteriUnvani</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Musteriler</span> </pre>
<pre><span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">MusteriID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">MusteriID</span><span class="p">)</span>
<span class="s1" style="color: #bb4444;">'Müşteri Adı Soyadı'</span><span class="p">,</span> <span class="p">(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">Adi</span><span class="o" style="color: #666666;">+</span><span class="s1" style="color: #bb4444;">' '</span><span class="o" style="color: #666666;">+</span><span class="n">SoyAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Personeller</span> </pre>
<pre><span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">PersonelID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">PersonelID</span><span class="p">)</span>
<span class="s1" style="color: #bb4444;">'Personel Adı Soyadı'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span>
<span class="c1" style="color: #008800; font-style: italic;">--Ürünler ile birlikte ürünün toplam satış adedi bilgisinide gösteren sorguyu yazınız.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">Adet</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">UrunID</span><span class="p">)</span> <span class="s1" style="color: #bb4444;">'ADET'</span> </pre>
<pre> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--Yapılan satışları maximum satış fiyatı bilgisi ile listeleyiniz</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">MAX</span><span class="p">(</span><span class="n">Fiyat</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">SatisID</span><span class="o" style="color: #666666;">=</span><span class="n">Satislar</span><span class="p">.</span><span class="n">SatisID</span><span class="p">)</span><span class="s1" style="color: #bb4444;">'MAXFİYAT'</span></pre>
<pre> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürünleri ürüne uygulanan maximum indirim yüzdesi bilgisi ile birlikte listeleyen </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--sorguyu yazınız.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span><span class="p">,(</span><span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">MAX</span><span class="p">(</span><span class="n">Indirim</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="n">Urunler</span><span class="p">.</span><span class="n">UrunID</span><span class="p">)</span></pre>
<pre><span class="s1" style="color: #bb4444;">'max indirim'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--Yapılan satışları toplam satış tutarları ile birlikte listeleyen sorguyu yazınız</span></pre>
</div>
</td></tr>
</tbody></table>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-29931232594302470102018-01-19T17:33:00.000+03:002018-01-19T17:33:20.553+03:00SQL GROUP BY KULLANIMI<table class="pastetable" style="color: black; font-family: Verdana, arial, helvetica, sans-serif;"><tbody>
<tr><td class="linenos" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="linenodiv" style="border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; margin: 0px; padding: 0px;">
<pre> 1
2
3
4
5
6
7
8
9
<span class="special">10</span>
11
12
13
14
15
16
17
18
19
<span class="special">20</span>
21
22
23
24
25
26</pre>
</div>
</td><td class="code" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="paste" style="background-color: #eeeeee; border-radius: 4px; border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; color: black; margin: 0px; padding: 0px;">
<pre>
</pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--notlar count=saymak sum=toplam average=ortalama</span>
<span class="c1" style="color: #008800; font-style: italic;">--GROUP BY KULLANIMI</span>
<span class="c1" style="color: #008800; font-style: italic;">--Group by : Tablo içindeki verileri gruplamayı saglar.</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi kategoriden kaç tane ürün vardır. </span>
<span class="c1" style="color: #008800; font-style: italic;">--not: Soruda hangi kelimesi geçiyorsa orada group by vardır.</span>
<span class="c1" style="color: #008800; font-style: italic;">--not: Hangi kolunu group by ladıysak o kolonu yazdırmamız lazım</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">kategoriId</span> <span class="p">,</span> <span class="k" style="color: #aa22ff; font-weight: bold;">count</span><span class="p">(</span><span class="o" style="color: #666666;">*</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">KategoriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--stokta hangi kategoriden kaç dolarlık ürün vardır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">KategoriID</span><span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">Fiyat</span><span class="o" style="color: #666666;">*</span><span class="n">Stok</span><span class="p">)</span> <span class="s1" style="color: #bb4444;">'toplam tutar'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">KategoriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--hangi kategoriden stokta kaç adet ürün vardır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">KategoriID</span> <span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">STOK</span><span class="p">)</span> <span class="s1" style="color: #bb4444;">'TOPLAM STOK ADEDİ'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">KategoriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi tedarikçiden kaç adet ürün tedarik edilmiştir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">TedarikciID</span> <span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">count</span><span class="p">(</span><span class="n">TedarikciID</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">FROM</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">TedarikciID</span>
<span class="c1" style="color: #008800; font-style: italic;">--hangi tedarikçiden stokta toplamda kaç dolarlık ürün vardır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">TedarikciID</span> <span class="p">,</span> <span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">Stok</span><span class="o" style="color: #666666;">*</span><span class="n">fiyat</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">TedarikciID</span>
<span class="c1" style="color: #008800; font-style: italic;">--hangi personel hangi müşteriye kaç adet satış yapmıştır (satıslar tablosu)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">PersonelID</span><span class="p">,</span><span class="n">MusteriID</span><span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">count</span><span class="p">(</span><span class="o" style="color: #666666;">*</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">PersonelID</span><span class="p">,</span><span class="n">MusteriID</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi müşteri hangi nakliyeciden kaç adet siparişte bulunmuştur</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--(nakliyeci=shipvia kolonudur)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">MusteriID</span><span class="p">,</span><span class="n">ShipVia</span><span class="p">,</span><span class="k" style="color: #aa22ff; font-weight: bold;">count</span><span class="p">(</span><span class="o" style="color: #666666;">*</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Satislar</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">MusteriID</span><span class="p">,</span><span class="n">ShipVia</span>
<span class="c1" style="color: #008800; font-style: italic;">--Hangi üründen toplamda kaç dolarlıksatış yapılmıştır ve büyükten küçüge</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--sıralayınız(satısdetay)</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">UrunID</span> <span class="p">,</span> <span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">Fiyat</span><span class="o" style="color: #666666;">*</span><span class="n">adet</span><span class="o" style="color: #666666;">*</span><span class="p">(</span><span class="mi" style="color: #666666;">1</span><span class="o" style="color: #666666;">-</span><span class="n">Indirim</span><span class="p">))</span> <span class="s1" style="color: #bb4444;">'satış miktarı'</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">SatisDetay</span> <span class="k" style="color: #aa22ff; font-weight: bold;">group</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">UrunID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">order</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="p">[</span><span class="n">satış</span> <span class="n">miktarı</span><span class="p">]</span> <span class="k" style="color: #aa22ff; font-weight: bold;">desc</span></pre>
</div>
</td></tr>
</tbody></table>
<br />halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-29782316629919956802018-01-19T11:35:00.001+03:002018-01-19T16:07:23.709+03:00SQL AGGREGATE FONKSİYONLARI<pre><span class="c1" style="color: #008800; font-style: italic;">--AGGREGATE FUNCTION</span>
<span class="c1" style="color: #008800; font-style: italic;">--aggregate=toplam,bütün anlamına gelir. 5 tane alt başlıgımız vardir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--aggregate functionlar select ile from arasına yazılırlar</span>
<span class="c1" style="color: #008800; font-style: italic;">--1-) Count()-->satır adedini veren fonksiyondur. count=saymak </span>
<span class="c1" style="color: #008800; font-style: italic;">--Kaç adet kategori vardır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">COUNT</span> <span class="p">(</span><span class="o" style="color: #666666;">*</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Kategoriler</span>
<span class="c1" style="color: #008800; font-style: italic;">--kategoriler tablosunda kaç adet " Tanimi " satırı vardır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">count</span><span class="p">(</span><span class="n">Tanimi</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">kategoriler</span> <span class="c1" style="color: #008800; font-style: italic;">-- 11 degilde 9 geldi çünkü Tanimi'de 2 hücre </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">null oldugu için</span>
<span class="c1" style="color: #008800; font-style: italic;">--2-)Sum toplam işlemi yapmamızı saglayan fonksiyondur. sum=toplam</span>
<span class="c1" style="color: #008800; font-style: italic;">--Stokta kaç adet ürün bulunmaktadır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span><span class="p">(</span><span class="n">Stok</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--stokta bulunan ürünlerin toplam fiyatını bulunuz</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">SUM</span> <span class="p">(</span><span class="n">Fiyat</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span><span class="c1" style="color: #008800; font-style: italic;">--burada sadece fiyatları toplar getirir.</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">--Cevap bu degildir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">Fiyat</span><span class="o" style="color: #666666;">*</span><span class="n">Stok</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="c1" style="color: #008800; font-style: italic;">-- dogrusu budur</span>
<span class="c1" style="color: #008800; font-style: italic;">--3-)AVG ortalama almaya yarayan fonksiyondur. average=ortalama</span>
<span class="c1" style="color: #008800; font-style: italic;">--stogumuz da toplam kaç adet ürün vardır </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">AVG</span><span class="p">(</span><span class="n">stok</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--stogumuzda ortalama fiyat olarak ne kadarlık ürün vardır</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">AVG</span><span class="p">(</span><span class="n">fiyat</span><span class="o" style="color: #666666;">*</span><span class="n">stok</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--4-)MAX fonksiyonu--> belirtilen kolon içinden degeri max olandegeri getirir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--stogu en yüksek olan ürünü getiriniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">max</span><span class="p">(</span><span class="n">stok</span><span class="p">)</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--5-)MIN fonksiyonu --> belirtilen kolon içinde degeri en az olan degeri getirir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--Fiyatı en az olan ürünün fiyatını gösteriniz </span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">MIN</span><span class="p">(</span><span class="n">Fiyat</span><span class="p">)</span> <span class="s1" style="color: #bb4444;">'EN DÜŞÜK FİYAT'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="c1" style="color: #008800; font-style: italic;">-- BURADA KOLON ADINI DA TIRNAK</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">İÇİNDE BELİRTMİŞ OLDUK</span>
<span class="c1" style="color: #008800; font-style: italic;">--Toplam fiyat olarak ne kadarlık ürün satışı yapılmıştır</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="k" style="color: #aa22ff; font-weight: bold;">sum</span><span class="p">(</span><span class="n">Fiyat</span><span class="o" style="color: #666666;">*</span><span class="n">Adet</span><span class="o" style="color: #666666;">*</span><span class="p">(</span><span class="mi" style="color: #666666;">1</span><span class="o" style="color: #666666;">-</span><span class="n">Indirim</span><span class="p">))</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">SatisDetay</span></pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-82986631708484295702018-01-18T22:17:00.004+03:002018-01-19T11:40:25.283+03:00SQL WHERE , BEETWEN, LİKE, IN ,ORDER BY KULLANIMI<pre><span style="color: #008800;"><i> Merhaba arkadaşlar, bugün sizlerler sql ile ilgili 1.dersimizi yapacagız.</i></span></pre>
<pre><span style="color: #008800;"><i> Örneklerle ilerleyecegiz. Kullanıdıgım veritabanı MSSQL, kullandığım tablolar</i></span></pre>
<pre><span style="color: #008800;"><i> ise KUZEY YELİ veritabanına aittir. Kuzey yelini internetten indirip aynı</i></span></pre>
<pre><span style="color: #008800;"><i> örnekleri sizde </i></span><i style="color: #008800;">uyğulayabilirsiniz. Kolay gelsin.</i></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">
</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">-- WHERE KOMUTU VE ALT BAŞLIKLARI</span>
<span class="c1" style="color: #008800; font-style: italic;">--WHERE İLE KULLANILAN BAZI BEETWEN, LİKE, IN</span>
<span class="c1" style="color: #008800; font-style: italic;">--LIKE KOMUTU ÖRNEKLER</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunID</span><span class="o" style="color: #666666;">=</span><span class="mi" style="color: #666666;">5</span><span class="p">;</span>
<span class="c1" style="color: #008800; font-style: italic;">--Fiyatı 50den büyük olan ürünleri listele</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Fiyat</span><span class="o" style="color: #666666;">></span><span class="mi" style="color: #666666;">50</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">KategoriID</span><span class="o" style="color: #666666;">=</span><span class="mi" style="color: #666666;">6</span>
<span class="c1" style="color: #008800; font-style: italic;">--stogu 20 den küçük olan verileri listele</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Stok</span><span class="o" style="color: #666666;"><</span><span class="mi" style="color: #666666;">20</span>
<span class="c1" style="color: #008800; font-style: italic;">--adı Chang olan urunu getir</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span><span class="o" style="color: #666666;">=</span><span class="s1" style="color: #bb4444;">'Chai'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adının ilk harfi c ile başlasın sonu önemli degil</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'a%'</span> <span class="c1" style="color: #008800; font-style: italic;">-- like komutu ile </span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adının son harfi a gerisi önemli degil</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'%a'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adı a ile başlatyıp p ile bitsin</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'a%up'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adı ya c ile veya a veya b ile başlayanları getirsin</span>
<span class="c1" style="color: #008800; font-style: italic;">--**ÖNEMLİ Burada _ kaç karakterden oluşacagını belirtiyor.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Urunadi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'[c,a,b]%'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adının sondan 2. karakteri c olanları getir.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'%c_'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürünün adında c harfi geçenleri listele</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">WHERE</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'%c%'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adında "sos" geçen ürünadlarını listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'%sos%'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adı s ile başlayıp e ile biten ürünleri listele</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'s%%e'</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adının 2. harfi a veya e olanları listeleyiniz</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'_[a,e]%'</span>
<span class="c1" style="color: #008800; font-style: italic;">-- ürünün sondan 2. harfi t veya l olan ve k ile başlayan ürüleri listeleyin</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'c%[_t,l]_'</span>
<span class="c1" style="color: #008800; font-style: italic;">--IN KOMUTU ÖRNEKLER</span>
<span class="c1" style="color: #008800; font-style: italic;">--in= bir den fazla komutu aynı anda uygulamamızı saglayan komutur.</span>
<span class="c1" style="color: #008800; font-style: italic;">--in=içinde demektir</span>
<span class="c1" style="color: #008800; font-style: italic;">--UrunId si 5,7,9,11 olan ürünleri listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">in</span> <span class="p">(</span><span class="mi" style="color: #666666;">5</span><span class="p">,</span><span class="mi" style="color: #666666;">7</span><span class="p">,</span><span class="mi" style="color: #666666;">9</span><span class="p">,</span><span class="mi" style="color: #666666;">11</span><span class="p">)</span>
<span class="c1" style="color: #008800; font-style: italic;">--Ürün adı chai ve chang olan ürünleri listeleyin</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">in</span> <span class="p">(</span><span class="s1" style="color: #bb4444;">'chang'</span><span class="p">,</span><span class="s1" style="color: #bb4444;">'chai'</span><span class="p">)</span>
<span class="c1" style="color: #008800; font-style: italic;">--BETWEEN KOMUTU ÖRNEKLER</span>
<span class="c1" style="color: #008800; font-style: italic;">--Between arasında demektir.</span>
<span class="c1" style="color: #008800; font-style: italic;">--urunıd si 5 ile 11 arasındaki ürünleri listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunID</span> <span class="k" style="color: #aa22ff; font-weight: bold;">between</span> <span class="mi" style="color: #666666;">5</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="mi" style="color: #666666;">11</span>
<span class="c1" style="color: #008800; font-style: italic;">--Fiyatı 25 ile 75 arasında olankayıtları getiriniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">Fiyat</span> <span class="k" style="color: #aa22ff; font-weight: bold;">between</span> <span class="mi" style="color: #666666;">25</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="mi" style="color: #666666;">75</span>
<span class="c1" style="color: #008800; font-style: italic;">--SQL DE TOP KOMUTU</span>
<span class="c1" style="color: #008800; font-style: italic;">--Urunler tablosonda ilk 15 kaydı listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">top</span> <span class="mi" style="color: #666666;">15</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--urunler tablosunda ilk 3 kaydı listeleyiniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">top</span> <span class="mi" style="color: #666666;">3</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span>
<span class="c1" style="color: #008800; font-style: italic;">--ürün adı c ile başlayıp sondan 2. harfi n veya a olan ve</span>
<span class="c1" style="color: #008800; font-style: italic;">-- fiyatı 25 ile 75 arasında olan ilk 3 ürünü getiriniz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="n">top</span> <span class="mi" style="color: #666666;">2</span><span class="o" style="color: #666666;">*</span><span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'c%[n,a]_'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="n">Fiyat</span> <span class="k" style="color: #aa22ff; font-weight: bold;">between</span> <span class="mi" style="color: #666666;">25</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="mi" style="color: #666666;">75</span>
<span class="c1" style="color: #008800; font-style: italic;">--SQL DE ORDER BY KOMUTU</span>
<span class="c1" style="color: #008800; font-style: italic;">--order by komutu sıralama yapmak için kullanıır</span>
<span class="c1" style="color: #008800; font-style: italic;">--order=sipariş by=tarafından demektir</span>
<span class="c1" style="color: #008800; font-style: italic;">--Ürünleri, fiyatları çoktan aza dogru sıralayan listeyi oluşturunuz.</span>
<span class="c1" style="color: #008800; font-style: italic;">--descending=Azalan ascending=yükselen, artan demektir</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">order</span> <span class="k" style="color: #aa22ff; font-weight: bold;">by</span> <span class="n">Fiyat</span> <span class="k" style="color: #aa22ff; font-weight: bold;">DESC</span>
<span class="c1" style="color: #008800; font-style: italic;">--Dikkat edilirse where kullanılmadı.Çünkü bir kısıtlama söz konusu degil.</span>
<span class="c1" style="color: #008800; font-style: italic;">--BEETWEN, LİKE, IN Komutlarından herhangi birini kullanmış olsaydık kesinlikle</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;"> where de olacaktı</span>
<span class="c1" style="color: #008800; font-style: italic;">--kategori ıd si 5 olmayan ve ürün adının 2. harfi i olan ürünleri stoguna göre </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">tersten sırala</span> </pre>
<span class="k" style="color: #aa22ff; font-weight: bold;">select</span> <span class="o" style="color: #666666;">*</span> <span class="k" style="color: #aa22ff; font-weight: bold;">from</span> <span class="n">Urunler</span> <span class="k" style="color: #aa22ff; font-weight: bold;">where</span> <span class="n">UrunAdi</span> <span class="k" style="color: #aa22ff; font-weight: bold;">like</span> <span class="s1" style="color: #bb4444;">'_[i]%'</span> <span class="k" style="color: #aa22ff; font-weight: bold;">and</span> <span class="n">KategoriID</span><span class="o" style="color: #666666;">!=</span><span class="mi" style="color: #666666;">5</span> <span class="k" style="color: #aa22ff; font-weight: bold;">order</span> <span class="k" style="color: #aa22ff; font-weight: bold;">BY</span> <span class="n">Stok</span> <span class="k" style="color: #aa22ff; font-weight: bold;">DESC</span>halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-1980325434032097462017-12-27T02:01:00.000+03:002017-12-27T02:11:18.299+03:00İNSAN KELİMESİNİN KÖKENİ<div style="text-align: justify;"><div style="text-align: left;"><br />
<span style="font-family: "verdana"; font-size=3: x-small;"><span style="background-color: white;"> İnsan kelimesi kendinden türedigi ve kök olarak ise iki kelimeden bahsediliyor. Bunlardan birincisi "<u><b>üns </b></u>" dür. <b><u>Üns </u></b>kelimesinin anlamı ise <u>ünsiyet </u>(arkadaşlık) , yakınlık demektir. İkincisi ise "<u><b>nesy</b></u>"dir. <b>Nesy</b>, unutmak filinden geldigi söylenir. Buradan insanın unutkan bir varlık oldugu da belirtiliyor. </span></span><span style="background-color: white; font-family: "verdana"; font-size=3: x-small;">Kur’an’da insandan (Hz Adem) söz edilirken, <b>“Andolsun, önceden Adem’e ahid verdik de unuttu ve onu azim sahibi bulmadık.” (20/Tâhâ, 115)</b> buyrulur.(ahid=emir,görev)</span><br />
</div></div><div style="text-align: justify;"><div style="text-align: left;"><span style="background-color: white; font-family: "verdana"; font-size=3: x-small;"><br />
</span></div></div><div style="text-align: justify;"><div style="text-align: left;"><span style="background-color: white; font-family: "verdana"; font-size=3: x-small;"> Sonuc olarak insan =unutkan ve arkadaşcanlısı(huzuru bulmak istiyen) diye iki temele dayandıra bilir miyiz????</span></div></div><div style="text-align: justify;"><br />
</div><span style="background-color: white; font-family: "verdana"; font-size=3: x-small; text-align: justify;"><br />
</span> <br />
<span style="background-color: white; font-family: "verdana"; font-size=3: x-small; text-align: justify;"><br />
</span> <br />
<div style="text-align: center;"><span style="background-color: white; font-family: "verdana";font-size=3: x-small; text-align: justify;"><br />
</span></div><span style="background-color: white; font-family: "verdana"; font-size=3: x-small; text-align: justify;"> </span> halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-15536362458540453112017-12-10T09:00:00.000+03:002017-12-10T09:07:09.861+03:00PC Açıldığında Otomatik Program Başlatma WİN10 Merhaba Arkadaşlar bu yazıda sizlerle win10 da pc açılırken otomatik program başlatmayı öğreneceğiz.<br />
<br />
1-) Windows arama çubuğuna çalıştır yazılır.<br />
2-)Açılan ekrana shell:startup yazılır ve Tamam a basılır.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="227" data-original-width="427" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s320/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" width="320" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><br />3-)Bunları yaptıktan sonra açılan sayfaya istediğiniz programın kısa yolunu( örneğin Teamviewer, Skype) masaüstü'nden kopyalayıp bu sayfaya yapıştırmanız yeterlidir.<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVVFlmgW4iuxsJ7Pnv-vSyeAxjvgtUG91B2Xepikp7y9DqUAKYInmd_flKmrv0WWNben4xG-RBAWP52dsdgIzQTi-RX9hGnrkwZX0HWD-xasDGG98aCOEgq3dYk1hN-Z2fG1yqM6chw-s/s1600/windows+10+otomatik+program+ba%25C5%259Flatma.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-42062179736732109012017-11-10T00:52:00.000+03:002017-11-22T00:25:53.239+03:00wikipedia nasıl girilir Merhaba arkadaşlar şu sıralar ülkemizde wikipedia ' ya giriş yasaklandı. Şimdi sizlere<br />
<b>wikipedia</b> ' ya <b>şifresiz , vpn siz</b> çok basit bir şekilde nasıl gireceğinizi anlatacağım.<br />
<br />
Örneğin google " Java wikipedia " yazarsanız aşağıdaki ilk linke gidersiniz.<br />
<br />
<a href="https://tr.wikipedia.org/wiki/Java_(programlama_dili)">https://tr.wikipedia.org/wiki/Java_(programlama_dili) </a> <br />
<br />
Daha sonra bu çıkan linkde wikipedia nın önüne 0 eklerseniz siteye girecektir.( tr.<b>0</b>wikipedia )<br />
<br />
<a href="https://tr.0wikipedia.org/wiki/Java_(programlama_dili)">https://tr.<span style="color: red;"><b>0</b></span>wikipedia.org/wiki/Java_(programlama_dili)</a> bu şekilde<br />
<br />
ve artık wikipedia ' yı istediğiniz gibi kullanabilirsiniz.<br />
<br />
<br />halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-82999565457438519452017-11-01T12:44:00.002+03:002017-12-30T17:46:11.819+03:00Postgresql Valentina Kurulumu Linux KaliArkadaşlar bu gün ki yazımızda sizlere Linux Kali de PostgreSQL in nasıl pratik bir şekilde kurulacağını anlatacağım.<br />
sudo dpkg -i (deb uzantılı vstudio dosyası gelecek) yada<br />
sudo apt-get install vstudio<br />
<br />
<br />
Örnek :<br />
<br />
[12:50, 1.11.2017] Halil ibrahim: sudo dpkg -i /home/root/Downloads/vstudio_x64_7_lin.debhalilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-8960275206236605552017-06-03T00:00:00.001+03:002018-01-19T15:52:06.458+03:00Yıldız karakteri ile içi boş kare matrisi oluşturmaBu programdaki amacımız girilen sayı boyutunda içi boş kare matrisi oluşturmakdır.<br />
Örnek olarak girilen sayı 4 olsun ekran çıktımız aşagıdaki gibi olacaktır.<br />
<span style="color: red;">* * * *</span> <br />
* *<br />
* *<br />
<span style="color: red;">* * * *</span><br />
<pre><span class="cp" style="color: #008800;">#include <stdio.h></span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="nf" style="color: #00a000;">main</span><span class="p">()</span> <span class="p">{</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">kenar_uzunlugu</span><span class="p">;</span>
<span class="kt"> </span><span class="kt" style="color: #aa22ff; font-weight: bold;">char</span> <span class="n">simge</span> <span class="o" style="color: #666666;">=</span> <span class="sc" style="color: #bb4444;">'*'</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Kenar uzunluğunu giriniz...:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">kenar_uzunlugu</span><span class="p">);</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">for</span> <span class="p">(</span><span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">i</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">1</span><span class="p">;</span> <span class="n">i</span> <span class="o" style="color: #666666;"><=</span> <span class="n">kenar_uzunlugu</span><span class="p">;</span> <span class="n">i</span><span class="o" style="color: #666666;">++</span><span class="p">)</span> <span class="p">{</span> <span class="c1" style="color: #008800; font-style: italic;">//Üst yıldızlar için</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%c"</span><span class="p">,</span> <span class="n">simge</span><span class="p">);</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">" "</span><span class="p">);</span>
<span class="p">}</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"</span><span class="se" style="color: #bb6622; font-weight: bold;">\n</span><span class="s" style="color: #bb4444;">"</span><span class="p">);</span>
<span class="c1" style="color: #008800; font-style: italic;">// Uç kenarlara yıldızları yazdırmak için içi içe for döngüsü</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">for</span> <span class="p">(</span><span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">j</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">;</span> <span class="n">j</span> <span class="o" style="color: #666666;"><=</span> <span class="n">kenar_uzunlugu</span> <span class="o" style="color: #666666;">-</span> <span class="mi" style="color: #666666;">3</span><span class="p">;</span> <span class="n">j</span><span class="o" style="color: #666666;">++</span><span class="p">)</span> <span class="p">{</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">for</span> <span class="p">(</span><span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">i</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">;</span> <span class="n">i</span> <span class="o" style="color: #666666;"><=</span> <span class="n">kenar_uzunlugu</span><span class="p">;</span> <span class="n">i</span><span class="o" style="color: #666666;">++</span><span class="p">)</span> <span class="p">{</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="p">(</span><span class="n">i</span> <span class="o" style="color: #666666;">==</span> <span class="mi" style="color: #666666;">0</span><span class="p">)</span> <span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"* "</span><span class="p">);</span>
<span class="p">}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="p">(</span><span class="n">i</span> <span class="o" style="color: #666666;">==</span> <span class="n">kenar_uzunlugu</span> <span class="o" style="color: #666666;">-</span> <span class="mi" style="color: #666666;">3</span><span class="p">)</span> <span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">" *"</span><span class="p">);</span>
<span class="p">}</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">" "</span><span class="p">);</span>
<span class="p">}</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"</span><span class="se" style="color: #bb6622; font-weight: bold;">\n</span><span class="s" style="color: #bb4444;">"</span><span class="p">);</span>
<span class="p">}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">for</span> <span class="p">(</span><span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">i</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">1</span><span class="p">;</span> <span class="n">i</span> <span class="o" style="color: #666666;"><=</span> <span class="n">kenar_uzunlugu</span><span class="p">;</span> <span class="n">i</span><span class="o" style="color: #666666;">++</span><span class="p">)</span> <span class="p">{</span> <span class="c1" style="color: #008800; font-style: italic;">//Alt yıldızlar için</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%c"</span><span class="p">,</span> <span class="n">simge</span><span class="p">);</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">" "</span><span class="p">);</span>
<span class="p">}</span>
<span class="p">}</span></pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-41988909168470006102017-05-23T19:04:00.002+03:002018-01-19T16:08:28.071+03:00While döngüsü 2 Bu bölümde while ile 2. örnegimizi yapacağız.Örnegi açıklayacak olursak, kullanıcıdan not bilgisi alınacak bu notların ortalaması alınacak ama negatif olan sayılar ortalamaya alınmayacaktır. Kullanıcı istedigi kadar not girişi yapabilecektir. Çıkışı ise -1 ile yapacaktır.<br />
<br />
<pre><span class="cp" style="color: #008800;">#include <stdio.h></span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="nf" style="color: #00a000;">main</span><span class="p">()</span> <span class="p">{</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">not</span><span class="p">,</span> <span class="n">sayac</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">,</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">;</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">float</span> <span class="n">ortalama</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">;</span> <span class="c1" style="color: #008800; font-style: italic;">// ortalamamız kesirli sayı çıkabileceginden float</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">// tipinde tanımlıyoruz.</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Lütfen bir not giriniz (Çıkış için -1)...:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">not</span><span class="p">);</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">while</span> <span class="p">(</span><span class="n">not</span> <span class="o" style="color: #666666;">!=</span> <span class="o" style="color: #666666;">-</span><span class="mi" style="color: #666666;">1</span><span class="p">)</span> <span class="p">{</span> <span class="c1" style="color: #008800; font-style: italic;">//sonsuz döngü oluşturuldu, -1 girilmedigi sürece döngüye</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">// devam eder.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="p">(</span><span class="n">not</span> <span class="o" style="color: #666666;">>=</span> <span class="mi" style="color: #666666;">0</span><span class="p">)</span> <span class="p">{</span>
<span class="c1" style="color: #008800; font-style: italic;">//Girilen not pozitif mi kontrolü aksi halde ortalamaya ve sayaca dahil olmuyor.</span>
<span class="n">toplam</span> <span class="o" style="color: #666666;">=</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">+</span> <span class="n">not</span><span class="p">;</span>
<span class="n">sayac</span> <span class="o" style="color: #666666;">=</span> <span class="n">sayac</span> <span class="o" style="color: #666666;">+</span> <span class="mi" style="color: #666666;">1</span><span class="p">;</span>
<span class="p">}</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Lütfen bir not giriniz (Çıkış için -1)...:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">not</span><span class="p">);</span>
<span class="p">}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="p">(</span><span class="n">sayac</span> <span class="o" style="color: #666666;">==</span> <span class="mi" style="color: #666666;">0</span><span class="p">)</span> <span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Hiç not girilmemiştir...!!"</span><span class="p">);</span>
<span class="p">}</span> <span class="k" style="color: #aa22ff; font-weight: bold;">else</span> <span class="p">{</span>
<span class="n">ortalama</span> <span class="o" style="color: #666666;">=</span> <span class="p">(</span><span class="kt" style="color: #aa22ff; font-weight: bold;">float</span><span class="p">)</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">/</span> <span class="n">sayac</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"ortalama ...:%.2f"</span><span class="p">,</span> <span class="n">ortalama</span><span class="p">);</span>
<span class="c1" style="color: #008800; font-style: italic;">//float tipinin ekrana basarken burada .2 virgülden sonra ki hassasiyettir.</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">// Örneğin .4 olursa virgülden </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">//sonra 4 basamak gösterilirdi.</span>
<span class="p">}</span>
</pre>
<pre><span class="p">}</span></pre>
<span style="color: red;"><br /></span>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-662722455300171172017-05-23T15:13:00.003+03:002018-01-19T16:09:14.936+03:00While döngüsüC eğitiminin 3. yazısını yazıyoruz. Bu yazıda kullanıcıdan 5 tane not alıp ortalamasını bulan programı yazamaya çalışalım.<br />
<pre><span class="cp" style="color: #008800;">#include <stdio.h></span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="nf" style="color: #00a000;">main</span><span class="p">()</span> <span class="p">{</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">puan</span><span class="p">,</span> <span class="n">sayac</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">,</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">,</span> <span class="n">ortalama</span><span class="p">;</span> <span class="c1" style="color: #008800; font-style: italic;">//Burada toplam ve sayacı sıfıra eşitlemez </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">//isek değişkeni tuttugumuz hafıza lanındaki degeride toplamamış oluruz.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">while</span> <span class="p">(</span><span class="n">sayac</span> <span class="o" style="color: #666666;"><</span> <span class="mi" style="color: #666666;">5</span><span class="p">)</span> <span class="p">{</span> <span class="c1" style="color: #008800; font-style: italic;">//sayac 5 ten küçük oldugu sürece döngü devam edecektir.</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"notu giriniz..:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">puan</span><span class="p">);</span>
<span class="n">sayac</span> <span class="o" style="color: #666666;">=</span> <span class="n">sayac</span> <span class="o" style="color: #666666;">+</span> <span class="mi" style="color: #666666;">1</span><span class="p">;</span> <span class="c1" style="color: #008800; font-style: italic;">//sayacı her seferinde bir arttırıyoruz</span>
<span class="n">toplam</span> <span class="o" style="color: #666666;">=</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">+</span> <span class="n">puan</span><span class="p">;</span> <span class="c1" style="color: #008800; font-style: italic;">//girilen bütün sayıların toplamını bulmak için her seferinde</span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">// toplam ile puanı topluyoruz.</span>
<span class="p">}</span>
<span class="n">ortalama</span> <span class="o" style="color: #666666;">=</span> <span class="n">toplam</span> <span class="o" style="color: #666666;">/</span> <span class="mi" style="color: #666666;">5</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"sınıfın ortalaması..:%d"</span><span class="p">,</span> <span class="n">ortalama</span><span class="p">);</span>
<span class="p">}</span></pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-62238330871048570442017-05-23T11:19:00.003+03:002018-01-19T16:09:39.525+03:00if & elseC egitim serisinin 2. yazısını yazmaktayız. Bir önceki bloglarda deginilen noktalar direk geçilecektir. Bu yazımızda girilen sayının işaretini söyleyen programı yazacagız.<br />
<table class="pastetable" style="color: black; font-family: Verdana, arial, helvetica, sans-serif;"><tbody>
<tr><td class="linenos" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="linenodiv" style="border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; margin: 0px; padding: 0px;">
<pre> 1
2
3
4
5
6
7
8
9
<span class="special">10</span>
11
12
13
14
15
16
17
18
19</pre>
</div>
</td><td class="code" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="paste" style="background-color: #eeeeee; border-radius: 4px; border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; color: black; margin: 0px; padding: 0px;">
<pre><span class="cp" style="color: #008800;">#include <stdio.h></span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="nf" style="color: #00a000;">main</span><span class="p">()</span> <span class="p">{</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">sayi</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Bir sayı giriniz...:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span><span class="o" style="color: #666666;">&</span><span class="n">sayi</span><span class="p">);</span>
<span class="c1" style="color: #008800; font-style: italic;">//burada bir if else yapısının en önemli özelligi sadece ve sadece bir </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;">//yapının içi çalışacak olmasıdır.</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span><span class="p">(</span><span class="n">sayi</span><span class="o" style="color: #666666;">></span><span class="mi" style="color: #666666;">0</span><span class="p">)</span>
<span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Girilen sayı pozitiftir."</span><span class="p">);</span>
<span class="p">}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">else</span> <span class="k" style="color: #aa22ff; font-weight: bold;">if</span><span class="p">(</span><span class="n">sayi</span><span class="o" style="color: #666666;"><</span><span class="mi" style="color: #666666;">0</span><span class="p">)</span>
<span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Girilen sayı negatiftir ."</span><span class="p">);</span>
<span class="p">}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">else</span>
<span class="p">{</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"Girilen sayı 0'dır."</span><span class="p">);</span>
<span class="p">}</span>
<span class="p">}</span></pre>
</div>
</td></tr>
</tbody></table>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-45062752823283164782017-05-22T14:52:00.002+03:002018-01-19T16:10:36.987+03:00C ile ilk programMerhaba bugün sizlerle C diline giriş yapıp ilk programımızı yazacağız. Bu yazı, blog serimizin ilk yazısıdır. C'yi örnekler üzerinden işleyecegiz. Blog yazıları basit örnekler üzerinden gidecektir. İnsaallah sonunu getirmek nasip olur deyip ilk kodlarımızı yazalım. Programımız 2 sayıyı toplama işlemi yapacaktır, şimdi kodlarımızı yazalım.<br />
<br />
<table class="pastetable" style="color: black; font-family: Verdana, arial, helvetica, sans-serif;"><tbody>
<tr><td class="linenos" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="linenodiv" style="border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; margin: 0px; padding: 0px;">
<pre> 1
2
3
4
5
6
7
8
9
<span class="special">10</span>
11</pre>
</div>
</td><td class="code" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="paste" style="background-color: #eeeeee; border-radius: 4px; border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; color: black; margin: 0px; padding: 0px;">
<pre><span class="cp" style="color: #008800;">#include <stdio.h> */ dies ile başlayan satırlar </span></pre>
<pre><span class="cp" style="color: #008800;"> c kütüphaneleridir. Bu kütüphane i/o(printf, scanf vb.)</span></pre>
<pre><span class="cp" style="color: #008800;"> işlmeleri için gereklidir. Bu kütüphane yazmasakta kodlarımız çalışır,</span></pre>
<pre><span class="cp" style="color: #008800;"> ama bu kodda bir hata yaptığımızda run time error (ölümcül hatalardan </span></pre>
<pre><span class="cp" style="color: #008800;"> bir tanesidir.)</span></pre>
<pre><span class="cp" style="color: #008800;"> alabiliriz. Bu yüzden bu kütüphaneyi eklemeliyiz. /*</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="nf" style="color: #00a000;">main</span><span class="p">()</span> <span class="p">{</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">sayi1</span><span class="p">,</span> <span class="n">sayi2</span><span class="p">,</span> <span class="n">sonuc</span> <span class="o" style="color: #666666;">=</span> <span class="mi" style="color: #666666;">0</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"1.sayıyı giriniz...:"</span><span class="p">);</span> <span class="c1" style="color: #008800; font-style: italic;">//printf ile kullanıcıdan bilği istiyoruz.</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">sayi1</span><span class="p">);</span> <span class="c1" style="color: #008800; font-style: italic;">// bu format ile kullnıcıdan int tipinde </span></pre>
<pre><span class="c1" style="color: #008800; font-style: italic;"> //bir sayı girmesini istiyoruz</span></pre>
<pre> <span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"2.sayıyı giriniz...:"</span><span class="p">);</span>
<span class="n">scanf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="o" style="color: #666666;">&</span><span class="n">sayi2</span><span class="p">);</span>
<span class="n">sonuc</span> <span class="o" style="color: #666666;">=</span> <span class="n">sayi1</span> <span class="o" style="color: #666666;">+</span> <span class="n">sayi2</span><span class="p">;</span>
<span class="n">printf</span><span class="p">(</span><span class="s" style="color: #bb4444;">"%d"</span><span class="p">,</span> <span class="n">sonuc</span><span class="p">);</span> <span class="c1" style="color: #008800; font-style: italic;">// sonucu ekrana basıyoruz.</span>
<span class="p">}</span></pre>
</div>
</td></tr>
</tbody></table>
<br />halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-3586233259990217622017-03-19T16:06:00.000+03:002018-01-19T16:04:03.398+03:00JSP İLE DÖRT İŞLEM Meraba bu gün sizlere JSP de dört işlemi bir örnek ile açıklayacağım.<br />
İki tane sayfamız olacaktır ilk olarak frontend.jsp sayfamızı inceleyelim.<br />
<pre><span class="nt" style="color: green; font-weight: bold;"><html></span>
<span class="nt" style="color: green; font-weight: bold;"><head></span>
<span class="nt" style="color: green; font-weight: bold;"><title></span>Görüntü Sayfası<span class="nt" style="color: green; font-weight: bold;"></title></span>
<span class="nt" style="color: green; font-weight: bold;"></head></span>
<span class="nt" style="color: green; font-weight: bold;"><body></span>
<span class="c" style="color: #008800; font-style: italic;"><!-- Öncelikle bir form etiketi açıp metot ve action ları</span>
<span class="c" style="color: #008800; font-style: italic;">giriyoruz.Burada en önemli husus action(işlem yapılacak sayfanın</span>
<span class="c" style="color: #008800; font-style: italic;">ismini doğru vermektir). Sonra form elemanları ile frontendimizi</span>
<span class="c" style="color: #008800; font-style: italic;">oluşturuyoruz. Ve son olarak backend.jspsayfamıza verilerin</span>
<span class="c" style="color: #008800; font-style: italic;">gitmesi için bir submit button'u ekliyoruz. --></span>
<span class="nt" style="color: green; font-weight: bold;"><form</span> <span class="na" style="color: #bb4444;">method=</span><span class="s" style="color: #bb4444;">"post"</span> <span class="na" style="color: #bb4444;">action=</span><span class="s" style="color: #bb4444;">"backend.jsp"</span><span class="nt" style="color: green; font-weight: bold;">></span>
<span class="nt" style="color: green; font-weight: bold;"><input</span> <span class="na" style="color: #bb4444;">type=</span><span class="s" style="color: #bb4444;">"text"</span> <span class="na" style="color: #bb4444;">name=</span><span class="s" style="color: #bb4444;">"sayi1"</span><span class="nt" style="color: green; font-weight: bold;">></span>
<span class="nt" style="color: green; font-weight: bold;"><select</span> <span class="na" style="color: #bb4444;">name=</span><span class="s" style="color: #bb4444;">"secim"</span><span class="nt" style="color: green; font-weight: bold;">></span>
<span class="nt" style="color: green; font-weight: bold;"><option</span> <span class="na" style="color: #bb4444;">value=</span><span class="s" style="color: #bb4444;">"topla"</span><span class="nt" style="color: green; font-weight: bold;">></span>+<span class="nt" style="color: green; font-weight: bold;"></option></span>
<span class="nt" style="color: green; font-weight: bold;"><option</span> <span class="na" style="color: #bb4444;">value=</span><span class="s" style="color: #bb4444;">"cikar"</span><span class="nt" style="color: green; font-weight: bold;">></span>-<span class="nt" style="color: green; font-weight: bold;"></option></span>
<span class="nt" style="color: green; font-weight: bold;"><option</span> <span class="na" style="color: #bb4444;">value=</span><span class="s" style="color: #bb4444;">"carp"</span><span class="nt" style="color: green; font-weight: bold;">></span>*<span class="nt" style="color: green; font-weight: bold;"></option></span>
<span class="nt" style="color: green; font-weight: bold;"><option</span> <span class="na" style="color: #bb4444;">value=</span><span class="s" style="color: #bb4444;">"bol"</span><span class="nt" style="color: green; font-weight: bold;">></span>/<span class="nt" style="color: green; font-weight: bold;"></option></span>
<span class="nt" style="color: green; font-weight: bold;"></select></span>
<span class="nt" style="color: green; font-weight: bold;"><input</span> <span class="na" style="color: #bb4444;">type=</span><span class="s" style="color: #bb4444;">"text"</span> <span class="na" style="color: #bb4444;">name=</span><span class="s" style="color: #bb4444;">"sayi2"</span><span class="nt" style="color: green; font-weight: bold;">></span>
<span class="nt" style="color: green; font-weight: bold;"><input</span> <span class="na" style="color: #bb4444;">type=</span><span class="s" style="color: #bb4444;">"submit"</span><span class="nt" style="color: green; font-weight: bold;">></span>
<span class="nt" style="color: green; font-weight: bold;"></form></span>
<span class="nt" style="color: green; font-weight: bold;"></body></span>
<span class="nt" style="color: green; font-weight: bold;"></html></span></pre>
<br />
Frontend.jsp sayfamızın ekran çıktısı...<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPNWeD6Wd4O93kUtbotY8VdCCYyY_ZOzX0CeO40lB2GL35pLvXUVhCYlYqf6_72n67PbvvVpIYfH1JFb3W9e1yT-i_64vpEBmQJOyKahfPiYw5DC40hK3ORYzJ97UF26KH-CFo0mU48C4/s1600/Ekran+Al%25C4%25B1nt%25C4%25B1s%25C4%25B1.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="22" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPNWeD6Wd4O93kUtbotY8VdCCYyY_ZOzX0CeO40lB2GL35pLvXUVhCYlYqf6_72n67PbvvVpIYfH1JFb3W9e1yT-i_64vpEBmQJOyKahfPiYw5DC40hK3ORYzJ97UF26KH-CFo0mU48C4/s400/Ekran+Al%25C4%25B1nt%25C4%25B1s%25C4%25B1.PNG" width="400" /></a><br />
<br />
<br />
<br />
--------------------------------------<br />
Şimdi ise işlemin ve html içine java kodu yazdığımız backend.jsp<br />
sayfamızı inceleyelim.<br />
<table class="pastetable" style="color: black; font-family: Verdana, arial, helvetica, sans-serif;"><tbody>
<tr><td class="linenos" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="linenodiv" style="border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; margin: 0px; padding: 0px;">
<pre> 1
2
3
4
5
6
7
8
9
<span class="special">10</span>
11
12
13
14
15
16
17
18
19
<span class="special">20</span>
21
22
23
24
25</pre>
</div>
</td><td class="code" style="color: #888888; padding: 0px 0px 6px 12px;"><div class="paste" style="background-color: #eeeeee; border-radius: 4px; border: 0px; box-shadow: rgb(238, 238, 238) 0px 1px 5px; color: black; margin: 0px; padding: 0px;">
<pre><span class="nt" style="color: green; font-weight: bold;"><html></span>
<span class="nt" style="color: green; font-weight: bold;"><head></span>
<span class="nt" style="color: green; font-weight: bold;"><title></span>islem sayfası<span class="nt" style="color: green; font-weight: bold;"></title></span>
<span class="nt" style="color: green; font-weight: bold;"></head></span>
<span class="nt" style="color: green; font-weight: bold;"><body></span>
<span class="k" style="color: #aa22ff; font-weight: bold;"><%</span>
<span class="c1" style="color: #008800; font-style: italic;">//Burada gelen degerleri request.getparameter ile alıp integera </span>
<span class="c1" style="color: #008800; font-style: italic;">// çevirdikten sonra tanımladığımız gegişkenlere atıyoruz. </span>
<span class="c1" style="color: #008800; font-style: italic;">//equals ile kullanıcının hangi seçimi seçtigini belirleyip </span>
<span class="c1" style="color: #008800; font-style: italic;">// işlemleri yaptıktan sonra ekrana basıyoruz.</span>
<span class="kt" style="color: #aa22ff; font-weight: bold;">int</span> <span class="n">sayi1</span><span class="o" style="color: #666666;">,</span><span class="n">sayi2</span><span class="o" style="color: #666666;">,</span><span class="n">sonuc</span><span class="o" style="color: #666666;">;</span>
<span class="n">String</span> <span class="n">islem</span><span class="o" style="color: #666666;">;</span>
<span class="n">sayi1</span><span class="o" style="color: #666666;">=</span><span class="n">Integer</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">parseInt</span><span class="o" style="color: #666666;">(</span><span class="n">request</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">getParameter</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"sayi1"</span><span class="o" style="color: #666666;">));</span>
<span class="n">sayi2</span><span class="o" style="color: #666666;">=</span><span class="n">Integer</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">parseInt</span><span class="o" style="color: #666666;">(</span><span class="n">request</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">getParameter</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"sayi2"</span><span class="o" style="color: #666666;">));</span>
<span class="n">islem</span><span class="o" style="color: #666666;">=</span><span class="n">request</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">getParameter</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"secim"</span><span class="o" style="color: #666666;">);</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="o" style="color: #666666;">(</span><span class="n">islem</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">equals</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"topla"</span><span class="o" style="color: #666666;">))</span>
<span class="o" style="color: #666666;">{</span><span class="n">sonuc</span><span class="o" style="color: #666666;">=</span><span class="n">sayi1</span><span class="o" style="color: #666666;">+</span><span class="n">sayi2</span><span class="o" style="color: #666666;">;</span> <span class="n">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">print</span><span class="o" style="color: #666666;">(</span><span class="n">sonuc</span><span class="o" style="color: #666666;">);}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="o" style="color: #666666;">(</span><span class="n">islem</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">equals</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"cikar"</span><span class="o" style="color: #666666;">))</span>
<span class="o" style="color: #666666;">{</span><span class="n">sonuc</span><span class="o" style="color: #666666;">=</span><span class="n">sayi1</span><span class="o" style="color: #666666;">-</span><span class="n">sayi2</span><span class="o" style="color: #666666;">;</span> <span class="n">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">print</span><span class="o" style="color: #666666;">(</span><span class="n">sonuc</span><span class="o" style="color: #666666;">);}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="o" style="color: #666666;">(</span><span class="n">islem</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">equals</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"carp"</span><span class="o" style="color: #666666;">))</span>
<span class="o" style="color: #666666;">{</span><span class="n">sonuc</span><span class="o" style="color: #666666;">=</span><span class="n">sayi1</span><span class="o" style="color: #666666;">*</span><span class="n">sayi2</span><span class="o" style="color: #666666;">;</span> <span class="n">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">print</span><span class="o" style="color: #666666;">(</span><span class="n">sonuc</span><span class="o" style="color: #666666;">);}</span>
<span class="k" style="color: #aa22ff; font-weight: bold;">if</span> <span class="o" style="color: #666666;">(</span><span class="n">islem</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">equals</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">"bol"</span><span class="o" style="color: #666666;">))</span>
<span class="o" style="color: #666666;">{</span><span class="n">sonuc</span><span class="o" style="color: #666666;">=</span><span class="n">sayi1</span><span class="o" style="color: #666666;">/</span><span class="n">sayi2</span><span class="o" style="color: #666666;">;</span> <span class="n">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">print</span><span class="o" style="color: #666666;">(</span><span class="n">sonuc</span><span class="o" style="color: #666666;">);}</span><span class="k" style="color: #aa22ff; font-weight: bold;">%></span>
<span class="nt" style="color: green; font-weight: bold;"></body></span>
<span class="nt" style="color: green; font-weight: bold;"></html></span></pre>
</div>
</td></tr>
</tbody></table>
Frontend.jsp sayfamızın ekran çıktısı ---> 5 olacaktır.halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com0tag:blogger.com,1999:blog-6964678657575045562.post-37504416604192278092017-03-19T09:05:00.000+03:002018-01-19T16:06:36.286+03:00SPLİT VE TOCHARARRAY ANAHTAR SÖZCÜKLERİ<pre style="background-color: white; font-family: "Courier New";"> Merhaba bu yazımızda ilk olarak string bir ifadeyi,
bir char array dönüştürecegiz.
<b> </b>String <span class="n">kelime</span><span class="o" style="color: #666666;">=</span><span class="s" style="color: #bb4444;">"meraba ali"</span><span class="o" style="color: #666666;">;</span><pre> <span class="kt" style="color: #aa22ff; font-weight: bold;">char</span><span class="o" style="color: #666666;">[]</span> <span class="n">charArray</span><span class="o" style="color: #666666;">=</span><span class="n">kelime</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">toCharArray</span><span class="o" style="color: #666666;">();</span>
<span class="n">System</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">println</span><span class="o" style="color: #666666;">(</span><span class="n">Arrays</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">toString</span><span class="o" style="color: #666666;">(</span><span class="n">charArray</span><span class="o" style="color: #666666;">));</span>
<span class="n">System</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">println</span><span class="o" style="color: #666666;">(</span><span class="n">charArray</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">length</span><span class="o" style="color: #666666;">);</span><span class="c1" style="color: #008800; font-style: italic;">//char array in boyutu</span></pre>
Çıktı :
[m, e, r, a, b, a, , a, l, i]
10
Stringimizi artık bir char array olarak kullanabiliriz.
Burada ise string bir cümleyi string bir Array e atayalım.
<b>
</b>
<pre> <span class="n">String</span> <span class="n">cu</span><span class="n">mle</span><span class="o" style="color: #666666;">=</span><span class="s" style="color: #bb4444;">"Bu gün hava güneşli"</span><span class="o" style="color: #666666;">;</span>
<span class="c1" style="color: #008800; font-style: italic;">//burada boşluk referansına göre parçalıyor split(" ") yapmamız şart.</span>
<span class="n">String</span><span class="o" style="color: #666666;">[]</span> <span class="n">stringArrays</span><span class="o" style="color: #666666;">=</span><span class="n">cu</span><span class="n">mle</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">split</span><span class="o" style="color: #666666;">(</span><span class="s" style="color: #bb4444;">" "</span><span class="o" style="color: #666666;">);</span>
<span class="n">System</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">println</span><span class="o" style="color: #666666;">(</span><span class="n">Arrays</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">toString</span><span class="o" style="color: #666666;">(</span><span class="n">stringArrays</span><span class="o" style="color: #666666;">));</span>
<span class="n">System</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">out</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">println</span><span class="o" style="color: #666666;">(</span><span class="n">stringArrays</span><span class="o" style="color: #666666;">.</span><span class="na" style="color: #bb4444;">length</span><span class="o" style="color: #666666;">);</span></pre>
Çıktı :
[Bu, gün, hava, güneşli]
4
Artık girilen bir String'i, String Array olarak kullana biliriz.</pre>
halilibrahimoncelhttp://www.blogger.com/profile/00696081149047808309noreply@blogger.com1