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>

Tool untuk Filter Email Berdasarkan Domain dan Extract Email

Juli 15, 2015

1 komentar

Labels: C#, Carding, Hacking

<div><div dir="ltr" style="text-align: left;" trbidi="on">
kebetulan ane punya banyak mailist gan, dan mailistnya mau ane kelompokkin berdasarkan domain dari emailnya, kya gmail.com, yahoo.com, hotmail.com, live.com, dll. klo nglompokin satu2 kan lama, makannya ane buat toolnya sendiri<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://i.imgur.com/DGSZKl7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="http://i.imgur.com/DGSZKl7.png" width="400" /></a></div>
<br />
trus bsa jga untuk delete email dari domain tertentu, misal ane gak mau ada email dari gmail.com, yahoo, trus nanti hasilnya disimpen di satu file <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://i.imgur.com/30O8Ypj.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="211" src="http://i.imgur.com/30O8Ypj.png" width="400" /></a></div>
<br />
dan bisa untuk extract email dari suatu text gan, ane pke regex klo ini<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://i.imgur.com/jjRhV7Z.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="262" src="http://i.imgur.com/jjRhV7Z.png" width="400" /></a></div>
Download : http://www.mediafire.com/download/do7528fhzlooqa3/pisahemail.rar</div>
</div>

Fudanshi

Menampilkan Hanya Data yang Sama/Duplikat di SQL

Tool untuk Filter Email Berdasarkan Domain dan Extract Email

Recent Big Posts

Categories

Tags Cloud

Comments

Latest

Random

Flickr

4/Food

Popular Posts