SQL portal

Select distinct używamy jeżeli chcemy wyświetlić dane niepowtarzające sie tj. bez duplikatów, najbardziej będzie to widoczne na przykładzie:

w tabeli PRACOWNICY w kolumnie Imie mamy 4 rekordy Piotr, Marzena, Dominik, Piotr dwa z nich są identyczne, żeby wyświetlić dane bez duplikatów tj. powtarzające się dane wyświetlić tylko raz, używamy select distinct

SELECT DISTINCT nazwa_kolumny from NAZWA_TABELI;

......

Dostęp do całego artykułu tylko dla użytkowników zalogowanych!

stwórz swojego użytkownika: załóż nowe konto

obecnie masz status gościa

Komentarze

Dodaj nowy Szukaj

qdqew weqwe (93.159.6.xxx) Y-m-d H:i:s Chuj ci w dupe Odpowiedz 1 7

Re: qdqew (77.237.17.xxx) Y-m-d H:i:s spierdalaj pedale Odpowiedz 2 2

twoja stara to pedał :) (93.159.6.xxx) Y-m-d H:i:s twoja stara to pedał :) Odpowiedz 0 2

twoja stara to pedał :) (93.159.6.xxx) Y-m-d H:i:s Twój stary zresztą też :) Odpowiedz 0 1

twoja stara to pedał :) (93.159.6.xxx) Y-m-d H:i:s I nawet kurwa twój pies :) Odpowiedz 0 1

Nike Shox Nike Shox (65.49.2.xxx) Y-m-d H:i:s link:http://www.nikeshoxshoess.com/ shoes is becoming more and more popular among Nike series. Nike is king deserved to produce shoes. The link:http://www.nikeshoxshoess.com/mens-nike-shox- shoes-nike-shox-r4-c-1_18.html has been released several times and is the only shoe in the original lineup to have been released several times. link:http://www.nikeshoxshoess.com/mens-nike-shox- shoes-nike-shox-nz-c-1_42.html dedicate Top plate distributes impact forces from the heel to the columns. Current collections of link:http://www.newecyclingjersey.net/ include cycle shirts that are made from technologically advanced fabrics and they work in harmony with the rider and their body. Here we have link:http://www.newecyclingjersey.net/. For a loyal NFL football fan, owning link:http://www.cheapfalconsjersey.net/ is not excessive requirement for you, or no one will believe you are the real football freak.In our online store, we offer you various NFL ... Odpowiedz 0 0

Matt Leinart Jerseys Matt Leinart Jerseys (65.49.2.xxx) Y-m-d H:i:s Nike Shox shoes is becoming more and more popular among Nike series. Nike is king deserved to produce shoes. The Nike Shox R4 has been released several times and is the only shoe in the original lineup to have been released several times. Nike Shox NZ dedicate Top plate distributes impact forces from the heel to the columns. Current collections of Cycle Clothing include cycle shirts that are made from technologically advanced fabrics and they work in harmony with the rider and their body. Here we have Ag2r La Mondiale Jerseys. For a loyal NFL football fan, owning Atlanta Falcons Jerseys is not excessive requirement for you, or no one will believe you are the real football freak.In our online store, we offer you various NFL jerseys including Warrick Dunn NFL Jerseys and Matt Leinart Jerseys. There are ugg outlet of your favorite design. All the north face are at high quality and sophisticated workmanship. Odpowiedz 0 0

Napisz komentarz
Nick:
E-mail:	nie powiadamiajpowiadom
Strona www:
Tytuł:
Proszę wpisać kod antyspamowy widoczny na obrazku.