Sql Server

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Sql Server as PDF for free.

More details

  • Words: 100
  • Pages: 1
modul 10 2. cari nama dan alamat yang untuk semua pegawai yang bekerja pada departemen �research�. jawab: select e.fname, e.lname, e.address from employees e, departements d where e.dname=�research� and d.number=e.dno; 3. tampilkan nomor project, nomor department, nama manager department, alamat dan tangggal lahir, untuk project yang berlokasi di �stafford� jawab: select p.number, p.dnum, e.lname, e.address, e.bdate from project.p, departements d, employees e where p.location=�stafford� and p.dnum=d.number and m.mgrssn=e.ssn; 4. cari nama pegawai yang bekerja pada semua project yang dikontrol oleh nomor department 5. jawab: select e.fname, e.lname, p.pnumber from employees e, departements d, project p where d.number=�5�;

Related Documents

Sql Server
November 2019 28
Sql Server
November 2019 18
Sql Server
May 2020 11
Sql Server
November 2019 35
Sql Server
May 2020 13
Sql Server
April 2020 14