Union SQL data R dan data S

-

 Union R   U  S  merupakan penggabungan semua anggota relasi R dan relasi S dan membuang data yang duplikat.


tabel 1 dengan nama tabel siswa1



tabel 2 dengan nama tabel siswa2


Tampilkan seluruh IDSiswa yang terdapat pada instance Siswa S1 dan S2.


Query :

(SELECT IDSiswa FROM siswa1) UNION (SELECT IDSiswa FROM siswa2);


hasil :




Komentar

Posting Komentar

Postingan populer dari blog ini

ALAMAT PERUSAHAAN ASING DI INDONESIA

-
1. BRITISH PETROLEUM Perkantoran Hijau Arkadia, Tower D Jl. TB. Simatupang, Kav.88 Jakarta  12520 INDONESIA Attention : Manager Of Human Resources Development 2.  BRITISH   GAS   INTERNATIONAL   LIMITED Setiabudi   Atrium   Building ,  Suite  810 Jl. H.R. Rasuna Said Kav.62 Jakarta  12920 INDONESIA Attention : Manager Of Human Resources Development 3. ANADIAN PETROLEUM  INDONESIA Aminta House 4th Floor Jl. Letjen TB Simatupang Kav.10 Jakarta  12430 Attention : Manager Of Human Resources Development 4.  CONOCO   INDONESIA Mulia   Tower  5th Floor Jl. Gatot Subroto Kav 9-11 Jakarta  12930 INDONESIA Attention : Manager Of Human Resources Development 5. ENERGY EQUITY, LTD Plaza  89 - Suite 802 Jl. H.R Rasuna Said Kav.X-7/No.6 Jakarta  12940 INDONESIA Attention : Manager Of Human Resources Development 6. EXXONMOBIL OIL  INDONESIA Wisma GKBI, 27th-30th Floor Jl. Jenderal Sudirman 28 Jakarta  10012 INDONESIA Attention : Manager Of Human Resources Development 7.GULF  INDONESIA  RE
Baca selengkapnya

preparing oil and gas company

-
1. PT. PERTAMINA I have look at announcement that PT. pertamina is hiring talented young fresh graduate. PT. PERTAMNIA has opened recruitment campus in popular university in Indonesia including my university at the Universitas Gadjah Mada. Deadline registered this development graduate program on may, 31, 2017. I think that I am interesting for this position especially in electrical engineering. I actually apply for a job what I am interested there. I often apply for a job what I feel that this position is relevant to my background study. I have enroll my resume in my faculty and ECC UGM. I am convenient to obtain form in faculty of engineering. I hope I can fulfill the requirement for electrical engineering development program. I will be delighted to attend this selection of recruitment campus to entrance this oil and gas company. I hope that I can finish this test until final selection. 2. PT.BADAK NGL I also see an announcement that PT. BADAK NGL is also hiring recent graduate
Baca selengkapnya

Best JavaScript Debugging Tools

-
Gambar
Debugging JavaScript code can be real pain in ass as finding errors in bunch of code is quite time consuming and arduous task for developers. In this article we have gathered some of the  Best JavaScript Debugging Tools  that will turn out to be handy while debugging millions of JavaScript code without much hassle and help you to achieve more accurate results. If you are aware of any other JavaScript Debuggers, please let us know by posting a comment below. 1. Sublime Web Inspector If you use Sublime Text Editor for your JavaScript editing, then Sublime Web Inspector allows you to debug from the same program you edit with. It works on top of WebInspectorProtocol, with all information displayed in console and text files. 2. Js Bin JS Bin is an open source collaborative web development debugging tool. JS Bin allows you to edit and test JavaScript and HTML. Once you’re happy you can save, and send the URL to a peer for review or help. 3. JavaScript Debug This code provides a
Baca selengkapnya