25Mayıs

SQL Dersleri-3


Warning: Missing argument 1 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 2 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 3 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 4 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 5 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 6 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 7 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 8 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

Warning: Missing argument 9 for wp_get_related_posts(), called in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 268 and defined in /mounted-storage/home88a/sub005/sc46281-LYTF/nanelimon.net/wp-content/plugins/wp_related_posts.php on line 41

1)DISTINCT Deyimi

Evet arkadaşlar SQL de listeleme sorgularında yardımcı olacak kodlara devam ediyoruz.

Bu kodumuz şu işi yapıyor elinizde 100 kayıt var ve siz aynı olanları listelemek istemiyorsunuz, işte ilacımız bu kod;

SELECT DISTINCT ad FROM tablo1

Bu tabloda bu kodu çalıştırdığımızda;

AD SOYAD TELEFON
Ali Ercan 1234
Yahya Kaya 432
Ali Sönmez 143
Nuri Er 543

Sonucumuz şöyle olacak yani aynı olan adlardan sadece bir tanesini ve farklı olanları yazacak;

AD
Ali
Yahya
Nuri
  • No Related Post
 Yazının Etiketleri  

  1. Çalışmaların gayet başarılı. Sürekli takip etcem :)

  1. Geri bildirim yok.

Yorum yapın