Menampilkan Hanya Data yang Sama/Duplikat di SQL

Juli 28, 2015

<div><div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKJCcptX7JMM-NUpxtDiug3gRLvA4MoxXdWS2BiCKRQWg3b9V14orkcaKbRym6urIjFRG5lYzp68KyzGymHsWedQEMN2K3Hs3rQXTaSTLVbynVCSmm-pPzsNXTYnZj3yFazNEK_TpqzP8/s1600/download.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="267" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKJCcptX7JMM-NUpxtDiug3gRLvA4MoxXdWS2BiCKRQWg3b9V14orkcaKbRym6urIjFRG5lYzp68KyzGymHsWedQEMN2K3Hs3rQXTaSTLVbynVCSmm-pPzsNXTYnZj3yFazNEK_TpqzP8/s1600/download.jpg" /></a></div>
<br />
Ane punya tabel Buku degan record sbg berikut</div>
<pre>+----+-----------------------------------+------------------------+------------+
| id | judul                             | penulis                | terbitan   |
+----+-----------------------------------+------------------------+------------+
|  1 | SQL Script                        | Johan Paul Celay       | 2014-04-18 |
<span style="color: red;">|  2 | SQL PHP                           | Eko Riyanto            | 2015-05-10 |</span>
|  3 | Javacsript tutorial               | Paul Sanjay            | 2010-10-08 |
|  4 | Java Netbeans                     | Widi Sanjaya Putra     | 2009-12-09 |
|  5 | Pem. Web Dinamis                  | Widi Ardiyanto         | 2011-10-10 |
|  6 | C# for Beginner                   | Yuki Kashiwagi Sanjaya | 2013-03-13 |
<span style="color: red;">|  7 | Artifical Intellegence C++        | Okada Nana             | 2015-05-10 |</span>
|  8 | Unity Game Developer for Beginner | Sahar Nakayama         | 2013-10-08 |
|  9 | Kumpulan Algortima                | Ahmad Rizaldi          | 2007-12-05 |
| 10 | HKT48 History Rewiew              | Mayu watanabe          | 2009-12-20 |
+----+-----------------------------------+------------------------+------------+</pre>
<br />
yang ane kasih warna merah itu adalah record yang mempunyai data 'terbitan' yang sama. dan ane cuma mau nampilin data yang sama itu. ini perintahnya<br />
<br /></div>
<pre>select a.* from buku a inner join(select terbitan,count(*) as count from buku group by terbitan having count(*)>1) b on a.terbitan=b.terbitan;</pre>
<br />
dan hasilnya adalah</div>
<pre>+----+----------------------------+-------------+------------+
| id | judul                      | penulis     | terbitan   |
+----+----------------------------+-------------+------------+
|  2 | SQL PHP                    | Eko Riyanto | 2015-05-10 |
|  7 | Artifical Intellegence C++ | Okada Nana  | 2015-05-10 |
+----+----------------------------+-------------+------------+</pre>
<br />
referensi: http://stackoverflow.com/questions/2594829/finding-duplicate-values-in-a-sql-table</div>
</div>

Tidak ada komentar

Fudanshi

Menampilkan Hanya Data yang Sama/Duplikat di SQL

Recent Big Posts

Categories

Tags Cloud

Comments

Latest

Random

Flickr

4/Food

Popular Posts