SQL sonucu
Transkript
SQL sonucu
12.01.2016 Baskı görünümü phpMyAdmin 4.1.14 SQL sonucu Anamakine: mysql wampserver Veritabanı: asdasd Üretim Zamanı: 12 Oca 2016, 08:07:04 Üreten: phpMyAdmin 4.1.14 / MySQL 5.6.17 SQL sorgusu: SELECT tarih, COUNT(tarih) AS NumOccurrences FROM fiyatlar GROUP BY tarih HAVING ( COUNT(tarih) > 1 ); Satırlar: 152 Şu anki seçim benzersiz bir sütun içermiyor. Izgara düzenleme, işaretleme kutusu, Düzenle, Kopyala ve Sil özellikleri kullanılabilir değil. tarih NumOccurrences 20101221 2 20110103 2 20110104 2 20110106 3 20110110 2 20110216 2 20110221 2 20110311 2 20110315 2 20110318 2 20110331 2 20110401 2 20110404 2 20110407 2 20110503 2 20110505 2 20110509 2 20110517 2 20110530 2 20110601 2 20110621 2 20110629 2 20110908 2 20110912 2 20110921 2 20110922 2 20110923 2 20111011 2 http://localhost:82/phpmyadmin/sql.php?db=asdasd&table=fiyatlar&printview=1&sql_query=SELECT+tarih%2C%0D%0ACOUNT%28tarih%29+AS+Nu… 1/5 12.01.2016 Baskı görünümü phpMyAdmin 4.1.14 20111013 2 20111014 2 20111027 2 20111121 2 20111122 2 20111215 3 20120119 2 20120203 2 20120216 2 20120222 2 20120223 2 20120313 2 20120320 2 20120402 3 20120403 4 20120404 2 20120406 2 20120410 2 20120425 2 20120507 2 20120509 2 20120514 2 20120515 2 20120516 2 20120522 2 20120523 3 20120531 2 20120604 2 20120608 2 20120613 2 20120614 4 20120829 2 20120907 2 20120917 2 20120924 2 20120926 2 20121009 2 20121011 2 20121012 2 http://localhost:82/phpmyadmin/sql.php?db=asdasd&table=fiyatlar&printview=1&sql_query=SELECT+tarih%2C%0D%0ACOUNT%28tarih%29+AS+Nu… 2/5 12.01.2016 Baskı görünümü phpMyAdmin 4.1.14 20121015 2 20121016 2 20121112 2 20121120 2 20121122 2 20121123 2 20121126 3 20121129 2 20121205 2 20121220 2 20121228 2 20130114 3 20130116 3 20130117 2 20130121 14 20130125 2 20130208 2 20130219 2 20130221 2 20130228 2 20130307 2 20130319 4 20130320 3 20130321 4 20130322 2 20130326 3 20130401 2 20130409 2 20130418 2 20130429 2 20130430 2 20130502 2 20130503 2 tarih NumOccurrences 20130506 2 20130508 7 20130509 4 20130515 2 20130516 4 http://localhost:82/phpmyadmin/sql.php?db=asdasd&table=fiyatlar&printview=1&sql_query=SELECT+tarih%2C%0D%0ACOUNT%28tarih%29+AS+Nu… 3/5 12.01.2016 Baskı görünümü phpMyAdmin 4.1.14 20130517 2 20130520 2 20130528 2 20130529 2 20130530 2 20130531 2 20130605 2 20130606 2 20130611 2 20130821 2 20130822 2 20130826 3 20130827 2 20130829 2 20130903 2 20130910 2 20130911 2 20130912 2 20130923 2 20130930 3 20131119 2 20131125 2 20131126 2 20131206 3 20140212 2 20140217 2 20140303 3 20140304 2 20140312 2 20140317 2 20140318 2 20140324 2 20140325 2 20140327 2 20140401 2 20140402 2 20140414 2 20140903 2 20140911 2 http://localhost:82/phpmyadmin/sql.php?db=asdasd&table=fiyatlar&printview=1&sql_query=SELECT+tarih%2C%0D%0ACOUNT%28tarih%29+AS+Nu… 4/5 12.01.2016 Baskı görünümü phpMyAdmin 4.1.14 20140922 2 20141015 2 20150401 2 20150402 2 20150511 2 20150821 2 20151012 2 20151203 2 http://localhost:82/phpmyadmin/sql.php?db=asdasd&table=fiyatlar&printview=1&sql_query=SELECT+tarih%2C%0D%0ACOUNT%28tarih%29+AS+Nu… 5/5