23 - MySQL distinct kullanımı
use db01;
drop table if exists ogrenciler; --
create table if not exists ogrenciler (
id int primary key auto_increment,
ogr_no char(10) unique not null,
adi varchar(40),
sinif varchar(5),
sehir varchar(20),
note int
) ;
insert ogrenciler (ogr_no, adi, sinif, sehir, note) values
('220120','Seyma','3A','Malata',66),('220121','Selma','3A','Hatay',65),('220122','Kamil','3A','Kastamonu',55),
('230120','Salih','3A','İzmir',50), ('230121','Hatice','3A','Hatay',86), ('230122','Halim','3A','Adana',60),
('231120','Melih','3B','Adana',40), ('231121','Ömer' ,'3A','Hatay',97), ('231122','Faruk','3B','Malatya',70),
('232120','Melih','3B','Adana',35), ('232121','Berke' ,'3A','Adana',85), ('232122','Kazım','3B','Adana',80),
('231100','Sevda','3B','Hatay',45),('231521','Ömer' ,'3A','Hatay',75), ('231522','Sevil','3B','Malatya',90);