{"id":2159,"date":"2023-04-26T21:11:32","date_gmt":"2023-04-26T18:11:32","guid":{"rendered":"https:\/\/www.aydiner.gen.tr\/?p=2159"},"modified":"2023-05-12T00:40:27","modified_gmt":"2023-05-11T21:40:27","slug":"sql-sorgulari-ornek-calismalar","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2023\/04\/26\/sql-sorgulari-ornek-calismalar\/","title":{"rendered":"SQL Sorgular\u0131-\u00d6rnek \u00c7al\u0131\u015fmalar"},"content":{"rendered":"

ogrenci ad\u0131nda veritaban\u0131 olu\u015fturuldu.<\/strong><\/p>\n

CREATE DATABASE ogrenci<\/pre>\n
bilgi ad\u0131nda tablo olu\u015fturuldu. (ilgili veritaban\u0131 se\u00e7ilmelidir. yada ba\u015f\u0131na use (veritaban\u0131 ismi) yaz\u0131l\u0131r.)<\/strong><\/p>\n
CREATE TABLE bilgi(\r\nogrno INT PRIMARY KEY,\r\nogradsoyad VARCHAR(50) NOT NULL,\r\nsinif VARCHAR(50) NOT NULL,\r\ncinsiyet VARCHAR(50) NOT NULL,\r\ndtarihi DATE NOT NULL,\r\nokitapsayisi INT NOT NULL,\r\nkulubu VARCHAR(50) NOT NULL\r\n)<\/pre>\n
 <\/p>\n
 <\/p>\n
Bilgi Tablosuna Kay\u0131t Ekleme<\/strong><\/span><\/p>\n
\r\ninsert into bilgi(ogrno,ogradsoyad,sinif,cinsiyet,dtarihi,okitapsayisi,kulubu)\r\nvalues (4,'Zeynep AYDIN','10\/A','Kad\u0131n','2000-01-29',33,'Edebiyat'),\r\n(11,'Alp DEN\u0130Z','10\/A','Erkek','2000-02-12',33,'Fen ve Teknoloji'),\r\n(81,'Fatma AYDIN','10\/A','Kad\u0131n','2001-10-11',5,'Bili\u015fim'),\r\n(18,'Osman BERK','10\/A','Erkek','2000-02-20',33,'Spor'),\r\n(21,'Fatih USLU','10\/A','Erkek','2000-03-18',33,'Spor'),\r\n(45,'Nilay \u015eANSLI','10\/A','Kad\u0131n','2000-09-12',33,'Fen ve Teknoloji'),\r\n(23,'Okan BURUK','10\/A','Erkek','2000-04-22',33,'\u0130zcilik'),\r\n(9,'Ela ANKARALI','10\/A','Kad\u0131n','2000-04-22',33,'Bili\u015fim')\r\n<\/pre>\n
Bilgi Tablosundaki T\u00fcm Kay\u0131tlar G\u00f6ster<\/span><\/strong><\/p>\n
Select * from bilgi<\/pre>\n
Bilgi Tablosundaki \u00d6\u011frenci No ve Ad Soyad S\u00fctunlar\u0131n\u0131 G\u00f6ster<\/span><\/strong><\/p>\n
Select ogrno,ogradsoyad from bilgi<\/pre>\n
Bilgi Tablosundaki Erkek \u00d6\u011frencileri G\u00f6ster<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE cinsiyet='Erkek'<\/pre>\n
Bilgi Tablosundaki Erkek ve Okudu\u011fu Kitap Say\u0131s\u0131 10 dan fazla olan \u00d6\u011frencileri G\u00f6ster<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE cinsiyet='Erkek' AND okitapsayisi>10<\/pre>\n
Bilgi Tablosundaki \u00d6\u011frencileri Okul Numaras\u0131na G\u00f6re S\u0131ralama :<\/span><\/strong>
\nArtan S\u0131ralama:<\/p>\n
Select * FROM bilgi ORDER BY ogrno ASC<\/pre>\n
Azalan S\u0131ralama:<\/p>\n
Select * FROM bilgi ORDER BY ogrno DESC<\/pre>\n
Bilgi Tablosundaki 4 Nolu \u00d6\u011frencinin okudu\u011fu kitap say\u0131s\u0131n\u0131na 3 ekle<\/span><\/strong><\/p>\n
UPDATE bilgi SET okitapsayisi+=3 WHERE ogrno=4<\/pre>\n
Bilgi Tablosundaki 21 No lu \u00f6\u011frenci kayd\u0131 silme<\/span><\/strong><\/p>\n
DELETE FROM bilgi WHERE ogrno=21<\/pre>\n
Bilgi Tablosunda Ad\u0131 ‘A’ ile ba\u015flayan Kay\u0131tlar<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE ogradsoyad LIKE 'A%'<\/pre>\n
Bilgi Tablosunda Kul\u00fcb\u00fc i\u00e7inde Spor ve \u0130zcilik Ge\u00e7en Kay\u0131tlar<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE kulubu IN ('Spor','\u0130zcilik')<\/pre>\n
Bilgi Tablosunda Okudu\u011fu Kitap say\u0131s\u0131 10 ile 25 aras\u0131nda olan kay\u0131tlar<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE okitapsayisi BETWEEN 10 AND 25<\/pre>\n
Bilgi Tablosunda do\u011fum tarihi 2000 y\u0131l\u0131n\u0131n Ocak -Mart aylar\u0131 aras\u0131nda\u00a0 olan kay\u0131tlar<\/span><\/strong><\/p>\n
SELECT * FROM bilgi WHERE dtarihi BETWEEN '2000\/01\/01' AND '2000\/03\/03'<\/pre>\n
Bilgi Tablosunda Okunan Kitap Ortalamas\u0131<\/span><\/strong><\/p>\n
SELECT AVG(okitapsayisi) FROM bilgi<\/pre>\n
Bilgi Tablosundaki Toplam Kay\u0131t Say\u0131s\u0131<\/span><\/strong><\/p>\n
SELECT COUNT(*) FROM bilgi;<\/pre>\n
Bilgi Tablosundaki En \u00e7ok Kitap Okuyan Ki\u015fi<\/span><\/strong><\/p>\n
SELECT ogradsoyad,okitapsayisi FROM bilgi WHERE okitapsayisi =(SELECT MAX(okitapsayisi) FROM bilgi)<\/pre>\n
Bilgi Tablosundaki En az Kitap Okuyan Ki\u015fi<\/span><\/strong><\/p>\n
SELECT ogradsoyad,okitapsayisi FROM bilgi WHERE okitapsayisi =(SELECT MIN(okitapsayisi) FROM bilgi)<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
ogrenci ad\u0131nda veritaban\u0131 olu\u015fturuldu. CREATE DATABASE ogrenci bilgi ad\u0131nda tablo olu\u015fturuldu. (ilgili veritaban\u0131 se\u00e7ilmelidir. yada ba\u015f\u0131na use (veritaban\u0131 ismi) yaz\u0131l\u0131r.) […]<\/p>\n","protected":false},"author":1,"featured_media":2212,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[186,185,184],"class_list":["post-2159","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql-calisma-sorulari","tag-sql-sorgu-ornekleri","tag-sql-sorgulari"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=2159"}],"version-history":[{"count":17,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2159\/revisions"}],"predecessor-version":[{"id":2213,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/2159\/revisions\/2213"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media\/2212"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=2159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=2159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=2159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}