of 8

LATIHAN

Title: LATIHAN Author: IC Last modified by: IC Created Date: 12/15/2009 12:39:58 AM Document presentation format: On-screen Show Company: AMIKOM Other titles
0 views8 pages
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Documenttranscript
Title: LATIHAN 1 LATIHAN
  • Jalankan script sql berikut sekolah.sql
  • (membuat tabel sekaligus meng-entri data sekolah kurang lebih 200 record)
  • 2 Amati dan Cermati untuk masing-masing sintak sql berikut
  • A.1
  • select school_name,register_date from sekolah
  • A.2
  • select school_name,register_date from sekolah order by register_date asc
  • select school_name,register_date from sekolah order by register_date desc
  • 3
  • A.3
  • select from sekolah where establish_date between '1960/01/01' and '1970/12/31
  • A.4
  • (100 teratas untuk semua kolom)
  • Select top 100 from sekolah
  • (100 teratas untuk kolom nama sekolah)
  • Select top 100 school_name from sekolah
  • 4
  • A.5
  • select distinct(school_type) from sekolah
  • A.6
  • select count () from sekolah
  • select count () from sekolah where school_typeJH
  • select count () from sekolah where school_typeHS
  • 5
  • B2. LIKE and NOT LIKE
  • 1. select from sekolah where school_name like 'semarang
  • 2. select from sekolah where school_name like 'negeri
  • 3. select from sekolah where school_name like 'smp
  • 4. select from sekolah where school_name not like 'smp'
  • 6
  • B.3 OPERATOR LOGIC
  • Operator AND
  • select from sekolah where school_type'hs' and school_name like 'negeri
  • Operator OR
  • select from sekolah where school_type'hs' or school_name like 'negeri
  • Operator ltgt atau NOT
  • select from sekolah where school_type ltgt 'hs
  • select from sekolah where not school_type 'hs'
  • 7
  • C. Pengelompokan ? Group
  • select theme,school_name from sekolah group by theme,school_name
  • We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x